MS SQL Server:从该备份集进行读取时，RESTORE检测到在数据库.......

MS SQL Server数据库恢复出现如图错误提示：

System.Data.SqlClient.SqlError:从该备份集进行读取时，RESTORE检测到数据库"xxxxx"中的页(0:0)上存在错误。

经查看日志，发现如下信息

The backup data at the end of "E:[10.7.1.55]cargobookingdb.bak" is incorrectly formatted. Backup sets on the media might be damaged and unusable. To determine the backup sets on the media, use RESTORE HEADERONLY. To determine the usability of the backup sets, run RESTORE VERIFYONLY. If all of the backup sets are incomplete, reformat the media using BACKUP WITH FORMAT, which destroys all the backup sets.

怀疑是备份文件备份时出现了错误。重新备份数据库进行恢复后，错误不再提示，数据库恢复成功。

相关链接：【已解决】恢复数据库失败

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24389441/viewspace-1058271/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24389441/viewspace-1058271/