Post reply

Dbcc checkdb command

  • June 20, 2013 at 1:23 am

    #294886

    Dear Sir,

    Here i am having a doubt

    When we run DBCC CHECKDB command if we found any error we can fix them by using repair_fat,Repair_rebuild,Repair_allow_data_loss.

    If application team not ready for data loss we will restore the backup.if they are not ready to restore the backup also is there any another method to fix this issue.

  • June 20, 2013 at 1:56 am

    #1625737

    Repair is usually the last option for when there's no good backup.

    http://www.sqlservercentral.com/articles/Corruption/65804/

    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