how can I verify database consistency offline?

  • in order to check snapshots I would like to verify database consistency off-line.

    any ideas? tools?

    thanks.

  • I usually test backups by restoring them on a test server.

     

    Steven

  • In order to test snapshots as in SAN snapshots???  Or are you just talking about restoring and verifying off another copy of the database?  Or are you talking about testing backup files.

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • testing backup files without restoring

  • Try this....

    RESTORE VERIFYONLY

    from DISK = 'Filename.bak'

    HTH,

    Gopal

Viewing 5 posts - 1 through 4 (of 4 total)

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