January 17, 2012 at 4:13 am
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?
January 17, 2012 at 4:15 am
You can simply velidate the backup files integrity by restore verifyonly option.
January 17, 2012 at 4:21 am
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
January 17, 2012 at 5:12 am
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