July 18, 2004 at 5:09 am
in order to check snapshots I would like to verify database consistency off-line.
any ideas? tools?
thanks.
July 18, 2004 at 5:56 am
I usually test backups by restoring them on a test server.
Steven
July 18, 2004 at 12:07 pm
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.
July 18, 2004 at 11:54 pm
testing backup files without restoring
July 19, 2004 at 9:27 am
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