Restore SQL 2008 database fails with error on page xxx:xxx

Question

This is the situation:

Got a full backup (.bak file) of a SQL 2008 database, with partitions. The .bak file is 100gb.

I need to restore this database on a different server, to a new database. So, command is like this:

Restore Database [newname] FROM DISK= N'D:\mydatabase.bak' WITH FILE = 1
MOVE 'mydatabasename' TO 'C:\mydatabase.mdf'
MOVE 'Partition1' TO 'C:\`mydatabase_1.ndf'
etc..
STATS = 1

After 52 percent processed, I get this error:

Msg 3183, Level 16, State 2, Line 1
RESTORE detected an error on page (8481:555819297) in database "dbname" as read from the backup set.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Before all default suggestions come up, this is what I have already done:

• Checkdb on original database --> no errors
• Restore the .bak file on my local machine --> no errors, so the backup is correct.

What can I do to troubleshoot this? How can I get to the actual problem?

Thanks for any suggestions.

Answer 1

yeah for such restoration errors the problem lies in the drive from where you are trying to restore the backup,try changing the drive (e.g d to e )..it worked for me.

one can also try attaching mdf file directly.

Answer 2

We were able to restore the backup on other servers.

After a while, we switched over to a new server. The old one with the errors is on a test bench now.

Conclusion is that the backup file was correct, and the problem lies in a hardware problem on the server. Probably disk problemens, but when thats clear, i will post it here..

Thanks for the suggestions.

Answer 3

I'd check the MD5 checksums of the .bak as created on the server and after it's been moved to the new home. I'll bet something small got tweaked in your copy as you moved it over; something in your process, maybe just a network hiccup, borked something or other.

Few MD5 checksum utilities here: http://www.thefreecountry.com/utilities/free-md5-sum-tools.shtml

Best of luck.