Maintanance Plans

• Chinna-703814

  SSC Enthusiast

  Points: 153

  More actions

  July 13, 2010 at 1:26 am

  #143993

  Hello,

  Here is my query for all the experts

  we are having 88 Databases on an instance and 20 maintanence plans to get the full,diff backups,reindexing of different sets of dbs (a-e,f-i and so on.........)

  i want to get the list of all maintanance plans and databases selected in that maint plan

  i have searched in the tables of MSDB to get the info there i found the set of tables.

  sysdbmaintplan_databases

  sysdbmaintplan_jobs

  sysdbmaintplan_history

  sysdbmaintplans

  with utter most happiness 🙂 i have queried the tables for the information and found that the tables are empty.

  can any one help me out with the good explanation.

  Thanks in advance

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  July 13, 2010 at 6:21 am

  #1191953

  Good explanation found in the BOL

  This table is included in Microsoft SQL Server 2005 to preserve existing information for instances upgraded from a previous version of Microsoft SQL Server. SQL Server 2005 does not change the contents of this table. This table is stored in the msdb database.

  This feature will be removed in the next version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  July 13, 2010 at 6:26 am

  #1191959

  Check these:

  dbo.sysmaintplan_plans

  dbo.sysmaintplan_subplans

  dbo.sysmaintplan_log

  dbo.sysmaintplan_logdetail