• GilaMonster - Monday, October 15, 2018 1:25 AM

    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)

    Never truer words have been said. You can even download some sample backups of corrupted databases here: https://www.sqlskills.com/sql-server-resources/sql-server-demos/

    If a database is corrupted that doesn't mean it can't still successfully be backed up and restored; and if it is (corrupted) then the corruption will be in both the backup and the restored database.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk