Restore backup

  • I have 250 Gigs backup file which need to be restore on exist database. I want to confirm restore should not fail in between. what can be done for this?

  • You can simply velidate the backup files integrity by restore verifyonly option.

    http://msdn.microsoft.com/en-us/library/ms188902.aspx

  • Unless the backup was taken WITH CHECKSUM, a restore verifyonly just checks the backup header and some metadata. It's entirely possible for a backup to verify but not restore.

    If the backup was taken WITH CHECKSUM, then a restore verifyonly is a good way to see if the backup will restore. If the backup wasn't taken WITH CHECKSUM, then the only way to be sure is by restoring the 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
  • A quick summary of the things you can do for database backup testing. The best thing you can do is to test the restore. There are some third party solutions that can help out. Let me know if you're interested.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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