August 2, 2012 at 9:09 pm
Hi All,
I hear that there are memory level corruption apart from IO corruption. If so, what could cause the memory level corruption.
Restore Verifyonly will report all errors kind of error? or only IO related? Can anybody help?
Thanks.
August 3, 2012 at 11:48 am
From what I understand, RESTORE VERIFYONLY will only check to see that the backup set is complete and readable, but it does not check the structure of the data particularly thoroughly; it will try to simulate an actual database restore as closely as it can, but it can be quite unreliable. The below MSDN article gives the full details:
http://msdn.microsoft.com/en-us/library/ms188902.aspx
Personally, I'd suggest doing a full RESTORE DATABASE on a dev environment if at all possible, followed by a DBCC CHECKDB on the restored database; the dev environment should be a different instance from your production instance, since RESTORE DATABASE flushes the cache on all databases in the instance.
- 😀
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply