Search code examples
sql-server-2008maintenance-plan

Backup SQL Server Maintenance Plan

Is it possible to backup Maintenance Plan? Is it enough to backup msdb database that has all Agent Jobs? I use SQL Server 2008.

Thanks.

Solution

  • 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.