Log in

View Full Version : Error while restoring a Sql Database using MSSQL 2005.


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/)