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-01-13 : 07:59:43
|
| Richard writes "I have created a maintenance plan to perform a database backup. This plan is scheduled to perform a full backup once a week and a transaction log backup daily. The backup is written to disk and works fine. My question; is it possible to backup directly to a network drive using an UNC path and how must I do this?Thanks alot.Richard." |
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2004-01-13 : 08:15:48
|
| how about mapping the network drive from your sql server, then choosing that location to backup to instead of C:\mssql7\etc or the like.? |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-01-13 : 08:26:07
|
| Don't use mapped drive letters, they can cause problems.You can backup to any drive or UNC location by using the TO DISK clause of the BACKUP command:BACKUP DATABASE myDB TO DISK='\\UNC\path\filename.bak'You can also restore from a backup file on a UNC:RESTORE DATABASE myDB FROM DISK='\\UNC\path\filename.bak' WITH REPLACEJust be aware of network permissions needed to read and write files to the UNC paths. And unless you are really pressed for disk space on the SQL Server itself, you should avoid backing up directly to UNC paths. Backup to the local drives instead and then copy/move the backup file to the UNC. |
|
|
|
|
|
|
Backup SQL Server Database