Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Zoroaster
Aged Yak Warrior
702 Posts |
 Posted - 2007-09-04 : 13:25:48
|
| I am looking for your expert opinions, how reliable is using "RESTORE VERIFYONlY" in determining if a backup is restorable?------------------------Future guru in the making. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-04 : 13:31:07
|
| SQL2000 = it isn't reliable.SQL2005 = it is close to reliable.However, nothing beats actually restoring the backup to a different machine and then performing a DBCC CHECKDBKristen |
 |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-04 : 13:48:37
|
quote:
Originally posted by Zoroaster
I am looking for your expert opinions, how reliable is using "RESTORE VERIFYONlY" in determining if a backup is restorable?------------------------Future guru in the making.
Thanks Kristen, I will keep this in mind.------------------------Future guru in the making. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-04 : 13:53:39
|
| it doesn't verify the data strucuture only page checksums if you backed up using WITH CHECKSUMS.so if you already backed up corrupt data the verify only might return ok even if you can't restore a backup.+1 on K-Bot's statement above._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
RESTORE VERIFYONLY