恢复 SQL 2008 数据库失败，页面 xxx:xxx 出现错误
情况是这样的：
获得了 SQL 2008 数据库的完整备份（.bak 文件），并带有分区。 .bak 文件大小为 100GB。
我需要将此数据库恢复到另一台服务器上的新数据库。 所以，命令是这样的：
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
处理完 52% 后，我收到此错误：
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.
在所有默认建议出现之前，这就是我已经完成的操作：
- Checkdb on original database -->没有错误
- 在我的本地计算机上恢复 .bak 文件 -->没有错误，所以备份是正确的。
我可以采取什么措施来解决这个问题？我怎样才能解决实际问题？
感谢您的任何建议。
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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
我会检查在服务器上创建的 .bak 以及将其移动到新家后的 MD5 校验和。我敢打赌，当你把它移过来时，你的副本中肯定有一些小东西被调整了；您的进程中出现了一些问题，可能只是网络故障、中断了某些事情或其他问题。
这里有一些 MD5 校验和实用程序： http://www.thefreecountry.com/utilities /free-md5-sum-tools.shtml
祝你好运。
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.
我们能够恢复其他服务器上的备份。
过了一段时间，我们切换到了新服务器。
旧的有错误的现在已经在测试台上了。
结论是备份文件是正确的，问题出在服务器硬件问题上。可能是磁盘问题，但是当情况清楚时，我会将其发布在这里..
感谢您的建议。
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.
是的，对于此类恢复错误，问题出在您尝试恢复备份的驱动器上，请尝试更改驱动器（例如 d 到 e ）..它对我有用。
也可以尝试直接附加 mdf 文件。
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.