DB Currupted

  • While taking the backup if the database is currupted what will we do?

  • Lee - Is this a "what if" question or did this really happen? If you are concerned that you may have a corrupted database and that the database backup you are creating is thereby corrupted as well, that certainly is a possibility. You should make sure that you are running DBCC Checkdb with no_infomsgs, all_errormsgs (check the syntax in BOL) on a regular basis to ensure that your database is not corrupt. If it is not then your backup should be ok.

    Please post with more information if I misunderstood the question or if you require any additional information.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • Lee From Bangalore (12/23/2008)


    While taking the backup if the database is currupted what will we do?

    Depending on the severity, fix the corruption, or restore a clean backup.

    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 3 posts - 1 through 2 (of 2 total)

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