Restore of .bak file returns error: 13(The data is invalid.)

Question

Post reply

Restore of .bak file returns error: 13(The data is invalid.)

al_dbd

Say Hey Kid

Points: 696
More actions
May 6, 2013 at 7:34 pm

#274802

Hello all....maybe someone can help me out - or break the bad news to me...
Restore error: 13 (The data is invalid).
Error Log information:"05/06/2013 19:28:13,Backup,Unknown,BackupIoRequest::ReportIoError: read failure on backup device 'F:\Backups\ToBeRestored\FullBackup.bak'. Operating system error 13(The data is invalid.).
05/06/2013 19:28:13,Backup,Unknown,Error: 18210<c/> Severity: 16<c/> State: 1."
Product: Sql Server 2012 SP1
OS: Windows Server 2008 R2 Standard SP1
I have googled my (what's left of my) brains out with this error....and all I have found is that it may lead to insufficient disk space; however, I'm leading towards it being corrupt.
I have run RESTORE FILELISTONLY and verified the file sizes...and according to that - I have enough disk space (with 100GB+ to spare).
I have run RESTORE HEADERONLY just to see if that would run.
I do get the same error (13 The data is invalid) when I try to run RESTORE VERIFYONLY.
This area definitely isn't my forte....so I apologize if this is a stupid question (or if I have posted in the wrong forum) 🙂
Is there ANY way to get find out what is causing the error - or to even get this data restored if it is a corrupt backup?
Thanks so much!

Viewing 13 posts - 1 through 12 (of 12 total)

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

SQLRNNR SSC Guru Points: 281324 More actions · Answer 1

Did restore headeronly produce the same error or did it run?

Also, do you have any IO related errors in the event logs?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

al_dbd Say Hey Kid Points: 696 More actions · Answer 2

I apologize - I didn't actually put that in the first post! Restore headeronly works just fine.

For your question "Also, do you have any IO related errors in the event logs? " - If you're speaking of the windows event log (sorry if I'm wrong - 🙁 - trying to learn, though!) - no others show up other than the same one in the sql error message...OS error 13 (The data is invalid).

Thanks so much.

Lee Ellen

Steve Jones - SSC Editor SSC Guru Points: 728164 More actions · Answer 3

I'd try to copy this file and restore it on another system. I suspect your file might be corrupt.

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

al_dbd Say Hey Kid Points: 696 More actions · Answer 4

Thanks. I am going to try that once I can get the hard drive hooked up to another machine tomorrow when I'm in the office.

If it fails as well, am I just out of luck with getting this backup restored?

Thanks!

SQLRNNR SSC Guru Points: 281324 More actions · Answer 5

I'm with Steve, I think the file might be corrupt.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

al_dbd Say Hey Kid Points: 696 More actions · Answer 6

So when y'all say the file might be corrupt - that could mean that the .bak file (on the client's end) might be okay - but the copy I have is corrupt?

It was sent to me on an external hard drive (I'm pretty sure - I'm not the one that actually hooks it up to the machines - I'm just doing the restore work). Could it possibly be something wrong with the drive? (bad sectors or something? - again - not my area of expertise 🙂 )

Thanks! 🙂

SQLRNNR SSC Guru Points: 281324 More actions · Answer 7

Well, it could be just your copy. It could be the drive that is no good. And it could also mean that the original bak file is also corrupt.

Attempting to restore to a different server could possibly help narrow that down.

Also, have you tried copying the bak file off of the external drive and to the server and then tried the restore?

It could be that the external drive is choking when you attempt the restore.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Steve Jones - SSC Editor SSC Guru Points: 728164 More actions · Answer 8

I'd also make another backup of the source database, ASAP.

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

al_dbd Say Hey Kid Points: 696 More actions · Answer 9

Yes, that was the last thing I tried before I posted my question here.

I received the same error. 🙁

I am waiting on a response from the client to see if they can restore the backup on their side.

I also created a md5 hash on the backup file we received and have asked the client to do the same to compare.

Thanks for all the assistance!

al_dbd Say Hey Kid Points: 696 More actions · Answer 10

Thanks, Steve. I'm definitely going to ask the client to verify their latest backup.

Thanks 🙂

kanhaiyapankaj SSC Enthusiast Points: 104 More actions · Answer 11

Have u check that your DB version is same.. or higher than BACKUP DB..?

al_dbd Say Hey Kid Points: 696 More actions · Answer 12

Yes, the customer is using 2012, and the instance I was trying to restore to was 2012 as well.

We are leaning towards the hard drive being bad.

Thanks to everyone for their input!