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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2005-03-01 : 07:02:26
|
| How to do a DB backup on the n/w?I tried mapping a n/w drive and taking the backup but this is not working?Is this possible in SQl server?------------------------I think, therefore I am |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-01 : 07:31:29
|
| Do not use mapped drives, use UNC paths instead.It is also better to back up to a local drive, then copy the backup file to the network drive. I've had more than a few backups get corrupted because of network hiccups. |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2005-03-01 : 07:34:07
|
| How to use UNC paths?------------------------I think, therefore I am |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-01 : 07:40:02
|
| \\myservername\myfoldername\myfilename.bak |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2005-03-02 : 01:30:32
|
| I have created a BACKUP DEVICE using UNC path and when i try to take the backup i am getting the message "Could not open backup device"------------------------I think, therefore I am |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-02 : 07:39:42
|
| Don't create a backup device. Use BACKUP DATABASE myDB TO DISK='unc path'.Again, I DO NOT recommend backing up directly to the network. |
|
|
|
|
|
|
Network backup