Post reply

is Dbcc checkdb command is checking the database log file also

  • March 25, 2011 at 12:44 am

    #237355

    is Dbcc checkdb command is checking the database log file also

  • March 25, 2011 at 2:03 am

    #1303392

    I don't think it does. Not 100% sure, checking...

    Why?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 25, 2011 at 2:26 am

    #1303401

    Thanks for reply,

    I had a problem of suspect DB so I have taken that DB into Emergency mode & ran Dbcc checkdb on database it doesen't showed any error so I executed Repair_rebuild command but it doesen't ran but throw an error that can not run Repair_rebuild.

    So i have tried to bring it online from emergrncy mode but it shows that log file was corrupt.

    so I am in doubt that while executing dbcc checkdb is checking log file or not if yes then why the checkdb is successful in my scenario?

  • March 25, 2011 at 2:28 am

    #1303403

    Can you post the errors?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 25, 2011 at 2:37 am

    #1303406

    The error was on production server so i cant copy it from there but whatever I have told is the exact situation happened.

    I have resolved that issue.

    My measure concern is that is DBCC CHECKDB command is checking log file of database also or is only checking data file and its objects.

  • March 28, 2011 at 8:30 am

    #1304392

    If your log file is corrupt then you cannot bring the Database online, unless you rebuild the log file. As far as the DBCC CHECKDB is concerned, here is what books online says:

    DBCC CHECKDB attempts to recover the database using regular log-based recovery techniques.

    HTH

    RK

Viewing 6 posts - 1 through 5 (of 5 total)

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