Post reply

integrity checks in maintenance plans

  • December 1, 2006 at 4:19 pm

    #68111

    Hi,

    I'm wondering what happens if a dbcc check fails in the integrity check of a maintenance plan.  Will the job show failed or do I have to look at an error log.  I don't have a corrupted database lying about, or I'd test it myself .

    Thanks!

    Sam

  • December 1, 2006 at 7:47 pm

    #675317

    I believe Job will fail...

    and don't configure to repair it because sometimes your db may with single user mode.

    You can corrupt the table in a db manually and test it.

    You can corrupt table by updating the sysindexes table for test...

    I think following update can corrupt table...use at your own risk and MS don't recommend to update system tables...

    update i

    set FirstIAM = '000000'

    FROM sysindexes where id = Object_id('<Table you want to corrupt>')

    Note: This just for testing don't try on prodcution server...

    MohammedU
    Microsoft SQL Server MVP

  • December 2, 2006 at 12:37 pm

    #675345

    The job should show failure, and you should have a notification set up to let you know. Check the logs for teh maintenance plan, not the job history for the details and then you can decide what to do.

    If you get corruption, you really should consider calling MS for support help in recovering your data.

  • December 2, 2006 at 3:09 pm

    #675348

    I will prefer running the integrity checks separately using WITH TABLERESULTS.. insert into a table and You can check programatically and send email notification...

    DBCC CHECKDB(pubs) WITH TABLERESULTS

    MohammedU
    Microsoft SQL Server MVP

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

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