Post reply

DBCC CHECKDB failed

  • July 2, 2007 at 8:06 am

    #177317

    We have a weekly job that runs the DBCC CHECKDB command and it shows in the log that it failed with the following

    DBCC CHECKDB (<Database&gt executed by <Domain>\<User> found 9 errors and repaired 0 errors. Elapsed time: 6 hours 8 minutes 10 seconds.

    DBCC CHECKDB error for Server <SERVER>, Database <Database>, error 8964. Check Event Viewer for additional details..

    How can I find out what went wrong or what the 9 errors were?

     

    Thanks

    Chad

  • July 2, 2007 at 8:32 am

    #716554

    If you're using the maintenance plan and logging is enabled you should find more information in the logfile. I'm not talking about the SQL errorLog, but the logfile for your maintenance job.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • July 3, 2007 at 7:07 am

    #716861

    The ouput of DBCC commands will be availabel in the error log file too. You can read them also to find what the errors that the checkdb has reported for.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

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

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