Backup is corrupted or not?

Question

Post reply

Backup is corrupted or not?

Chowdary's

SSCrazy

Points: 2978
More actions
September 17, 2014 at 10:42 pm

#299449

Hi All,
How can we know that backup is corrupted or not before restoring?
Regards
Chowdary...

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Vimal Lohani SSCommitted Points: 1650 More actions · Answer 1

Use

RESTORE FILELISTONLY FROM DISK = '<FILELOCATION>' WITH FILE = 1

GO

OR

restore headeronly from disk = 'c:\restore.bak'

If you will get null null in all columns then either the backup is corrupted or it is of high version.

Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature

spaghettidba SSC Guru Points: 105732 More actions · Answer 2

RESTORE VERIFYONLY is what you're looking for.

Relevant info here:

http://technet.microsoft.com/en-us/library/ms188902(v=sql.110).aspx

http://www.mssqltips.com/sqlservertip/1093/verifying-backups-with-the-restore-verifyonly-statement/

-- Gianluca Sartori

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Try to restore it and see if the restore fails.

Restore HeaderOnly only looks at the header, so only if the header is damaged will it give any indication. Restore VerifyOnly doesn't verify the entire backup, unless the backup was made WITH CHECKSUM

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

enriquemallon Ten Centuries Points: 1239 More actions · Answer 4

Hi

Gila Sir is right you should try to restore from backup first