Backup SQL Server Maintenance Plan
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
精彩评论