Home Forums SQL Server 2016 SQL Server 2016 - Administration Recovery of database RE: Recovery of database

  • October 15, 2018 at 1:25 am

    #2009540

    You don't. Run CheckDB.

    NorthernSoul - Thursday, October 11, 2018 6:43 AM

    You could try and restore it and see if it fails.

    Nah, I've seen enough corrupt DBs restore fine (with corruption in them)

    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