Post reply

DBCC Maintenance Plan runs too fast

  • October 4, 2007 at 2:35 am

    #182488

    Hi forum members,

    We have created a maintenance plan for checking database integrity (DBCC CHECKDB).

    When this plan runs over our four databases (SMD, master, model and msdb), it only takes 22 seconds to run.

    We have checked it over and it has been correctly created.

    However, when we run the command DBCC CHECKDB (SMD) manually, it takes 30 minutes to process (which is more like the runtime expected).

    Is there a known issue with this or does anyone have a fix?

    We are running SQL Server 2005 Version 9.0.3042

    Any help would be greatly appreciated.

    Thanks,

    Ben

  • October 4, 2007 at 6:40 pm

    #739383

    9.00.3042 had a bug where a maint plan would only run against the first database listed.

    fixed in 9.00.3054

    http://support.microsoft.com/?kbid=934458

    consider applying Cumulative Update #3 (August 2007). KB ;939537


    -- Amit


    "There is no 'patch' for stupidity."


    Download the Updated SQL Server 2005 Books Online.

  • October 5, 2007 at 8:04 am

    #739532

    Will give it a try!

    Thanks Amit

  • October 8, 2007 at 5:26 am

    #739943

    That did work!

    Thanks again Amit

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

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