[Mssqlcompressed-users] restore verifyonly
Brought to you by:
xclayl
From: Antonio R. Z. <Ant...@me...> - 2010-03-17 09:56:50
|
Hi, I was having a look at the Documentation and couldn't figure out if there is an option to do a "RESTORE VERIFYONLY". I.e.: I have 5 huge .bak files. So before doing a restore, to verify whether the .bak files are fine, I execute: --- RESTORE VERIFYONLY FROM BDVmyDb1, BDVmyDb2, BDVmyDb3, BDVmyDb4, BDVmyDb5 --- If they are not, I don't attempt to drop & restore the database. Cheers, Antonio |