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 |
|
learntsql
524 Posts |
 Posted - 2009-10-27 : 01:00:00
|
| Hi All,How to backup the database to another machine/server.Could you plz. tell me how to specify the destination path.while i am trying getting UNC path error.or any other methods. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-27 : 08:51:21
|
| BACKUP DATABASE AdventureWorksTO DISK='\\ServerName\SQLServerBackups\AdventureWorks1.bak'You need to give the SQL Server (and agent, maybe) service account permission to write to the location.What error are you getting? |
 |
|
|
arichings
Starting Member
6 Posts |
Posted - 2009-10-27 : 10:09:01
|
| Permission usually are the culprit in these cases, the account used to run the sql server needs to write to your UNC (share & NTFS permission)A.____________________Yep, its the end.... |
|
|
|
|
|
|
BackUp databse to another server/machine