There are times when we do a backup as a DBA, we come across problems when we restore the backup we made.

We may get error like this

Msg 3242,Level 16,State 2, Line 1

The fileon device C:\DBBackupCorrupted.BAK isnot a valid Format. The backup file made is not properly formed. 

Msg 3013,Level 16,State 1, Line 1

VERIFY DATABASEis terminating abnormally.

If we do not want this to get error when we restore. Always good to verify our backup file immediately after the backup is made and checkwhether it is corrupted or not.

In order  to verify run this command on a backup file

RESTORE VERIFYONLY FROM DISK = '<<location of database backup>>'

The above query results in vaid or not valid backup we have. We can sleep happily with the backup we have.





Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s