开发者

Backup SQL Server Maintenance Plan

开发者 https://www.devze.com 2023-03-24 11:06 出处:网络
Is it possible to backup Maintenance Plan? Is it enou开发者_开发问答gh to backup msdb database that has all Agent Jobs?I use SQL Server 2008.

Is it possible to backup Maintenance Plan? Is it enou开发者_开发问答gh to backup msdb database that has all Agent Jobs? I use SQL Server 2008.

Thanks.


Simple answer for this one - yes, keep your MSDB backed up as well as your other databases. (It contains details for other features as well, such as replication, backup history etc)

Edit : will add - back up your master as well whilst you are at it, if you are not doing that already.


You can both import and export maintenance plans. Connect to the Integration Services on the SQL Server instance that hosts the maintenance plans. Use the Stored Packages -> MSDB -> Maintenance Plans. Use the context menu of the Maintenance Plans and select the Import option

Or if you open the context menu of one of your maintenance plans, you can select either Import or or Export

0

精彩评论

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