Post reply

SQL 2005 to 2008 r2- Check data consistency

  • July 10, 2015 at 3:10 am

    #398724

    Hi Team,

    We are migrating our database from 2005 to 2008 r2.

    We are asked how are we making sure to check the data correctness post restoration.

    My thought is if the DB has been restored successfully, then there is no data corruption issue, I mean it wont be a case that certain data is corrupted and certain is not, or am I wrong here?.

    How can we check the data correctness post restoration?

  • July 10, 2015 at 3:12 am

    #1811530

    DBCC CheckDB is what you use to check corruption. SQL won't delete data or mangle data in an upgrade process. Corruption comes from hardware problems, usually IO subsystem.

    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 2 (of 2 total)

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