milas73
Nov 28, 2014, 08:42 AM
When i try to restore a DB from a database backup file i get the following error after 10% of the data has been restoredSystem.Data.SqlClient.SqlError: RESTORE detected an error on page (0:0) in database "dbName" as read from the backup set.(Microsoft.Sqlserver.Smo,
Does anybody have a fix for this or know what it means? Please help.
InfoJunkie4Life
Nov 28, 2014, 12:43 PM
Verify the database to see if it is corrupted.
RESTORE verifyonly FROM DISK='C:\Backup\Mydatabasefullbackup.bak';
You may also want to ensure that the original database you backed up from is not corrupted.
DBCC CHECKDB ('XXX') WITH NO_INFOMSGS, ALL_ERRORMSGS;
on the original machine.
Here's some info on corrupt databases:
Example 2000/2005 corrupt databases and some more info on backup, restore, page checksums and IO errors - Paul S. Randal (http://www.sqlskills.com/blogs/paul/example-20002005-corrupt-databases-and-some-more-info-on-backup-restore-page-checksums-and-io-errors/)