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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-29 : 07:28:19
|
| Carlos Silva writes "Hi guys,I need a little help regarding network backups...I have a Windows 2000 Advanced Server ( SP3 ) and SQL Server 2000 ( SP3a )...I am trying to connect a network drive, in order to perform a backup, but it doesn't see the any map drive... if i use a address pah like this '' \\server_names\c$\test.bak " it accepts, but in the end it give a error, saing that the device is off-line. do have any ideas..( I already tyied some solutions that are posted, but i only found for sql server 7...Thanks," |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-07-29 : 07:35:33
|
| Try this:BACKUP DATABASE mydbTO DISK='\\server_names\c$\test.bak'Also the SQL Server Service logon account must have access to the drive. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-29 : 12:29:48
|
| You should not backup your database over a network. If this is a one time thing or something that will happen occassionally, then fine, but if this is for a scheduled job, you should always backup your database to disk first then copy the backup file to tape or to another server. Backing your database up across a network is going to be very slow and prone to network problems, therefore it is not recommended.Tara |
|
|
|
|
|
|
Network Backup