/*-----code:start-----*/
RESTORE VERIFYONLY FROM DISK = 'D:\DB_Simulasi_20120717_1500.bak'
/*-----code:end-----*/
Result Messages:
The backup set on file 1 is valid.
It Means:
* File backup "DB_Simulasi_20120717_1500.bak" is ok.
Notes:
* Verifies the backup but does not restore it,
and checks to see that the backup set is complete and the entire backup is readable.
* However, RESTORE VERIFYONLY does not attempt to verify the structure of the data contained in the backup volumes.
* In Microsoft SQL Server, RESTORE VERIFYONLY
has been enhanced to do additional checking
on the data to increase the probability of detecting errors.
The goal is to be as close to an actual restore operation as practical.
* If the backup is valid, the SQL Server Database Engine returns a success message.
Source:
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/cba3b6a0-b48e-4c94-812b-5b3cbb408bd6.htm