Advertisements

SQL-BOX.COM

–SQL Server Storage

HOW TO VERIFY IF A BACKUP FILE IS CORRUPTED?

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.

 

 

 

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: