Post reply

Maintanance Plans

  • 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

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

  • July 13, 2010 at 6:26 am

    #1191959

    Check these:

    dbo.sysmaintplan_plans

    dbo.sysmaintplan_subplans

    dbo.sysmaintplan_log

    dbo.sysmaintplan_logdetail

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply