Hello all,
I would like to be able to backup our databases to a network share mapped drive. Is this possible? When every I go in to setup a maintenance plan it will only allow me to select local drive as the backup location. If my server crashes its not going to do a whole lot of good if my databases are stored locally (I do also backup up to tape every niight). I backup the databases every hour to local disk and would like to send them to one of my MS Storage Servers on the network.
Any help would be greatly appreciated.
thanks
Jason
YOu could use a network share using the UNC path, but if you want to make sure that the data is transfered correctly, I would stick saving the backup file to a local drive and copying it over afterwards using a restartable copying mechanism like robocopy or xcopy.
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||You don't need to do this if the SQL Server is running under a domain account. You simply need to ensure the SQL Server account has rights to the share you want to save your backups to. Then you can specify the network path to the share when creating the backup job/maintenance plan.
No comments:
Post a Comment