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. 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.
Also asked on stackoverflow, but they suggested to ask it on serverfault: Link to stackoverflow