Post reply

In what case do i need to run the DBCC CHECKDB?

  • May 13, 2009 at 6:27 am

    #384574

    Hi,

    what is the alert that we get on database consistency.... and how can we say the a particular table or a database is in inconsistant state....... how frequest should i run this when iam having very less transactions and my db size is only 40 GB.

    Thanks,

    Draj Pasarge

  • May 13, 2009 at 7:37 am

    #993708

    Run it often enough so that should it find corruption you can restore backups to fix it.

    Once a week is often a good place to start.

    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

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

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