Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2012-04-06 : 16:23:24
|
| Is to possible to backup the databases on to external file location or different server location not on the local machine. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-04-06 : 16:41:49
|
Absolutely.BACKUP DATABASE myDatabase TO DISK = '\\otherMachine\F$\directory\mydatabase.bak' |
 |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2012-04-06 : 22:02:29
|
| Thanks..I tried but i got below error..Executed as user...Cannot open backup device '\\Server\Test1\Test2\Test3\Test4\Backups\Folder$\DBTest.bak'. Operating system error 3(The system cannot find the path specified.).[SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.Can you please advise.. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-04-07 : 15:23:53
|
| Make sure the service account has write permissions on the directory. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-04-08 : 02:54:44
|
| Bad choice for doing a backup over a network.If your backup files are big it is gonna eat up your network.After Monday and Tuesday even the calendar says W T F .... |
|
|
|
|
|
|
Backup