How to take backup of database in SQL server on network location through a job?
I need to take the backup of database in SQL server on network location through creating a job in SQL server 2005.
can anyone know how to d开发者_开发技巧o it?
You can use a Maintenance Plan It will create a job manageble through Sql Server Agent, altenatively you can use SSIS (however the Maintenance Plans use SSIS).
One note, in the configuration of the backup activity you can browse only local path, however you can input the network path manually
Agree, backup location can be used as a UNC location. Can be managed by a maintenance plan or backup command in the SQL Agent job
精彩评论