开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜