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 - 2004-06-08 : 08:05:24
|
| Anthony writes "I have a MS SQL 7.0 Server which I have set up to run the backup to a remote server on my network. I tried to set up a MS SQL 2000 server the same way. I'm running Windows 2000 Server on the server with SQL 7.0 and Windows 2003 on the server with SQL 2000. I mapped a network drive and my backup jobs run through that mapped drive in SQL 7.0. I can not get SQL 2000 to see the Mapped drive. Is there anything I can do to get SQL 2000 to recognize the mapped drive?" |
|
|
MuadDBA
628 Posts |
Posted - 2004-06-08 : 09:24:24
|
| 1) Don't use backups to a mapped drive or network device. Backups are much too important for that. Back them up locally and then move the files using a scheduled job.2) Use the full UNC. |
 |
|
|
|
|
|
MS SQL Server 2000 Backup to Remote Server