2

I am using SQL Server 2008. While I am restoring database from backup file I got the error.

Restore failed for Server 'WIN-TUT3YRM1MMN\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)
System.Data.SqlClient.SqlError: RESTORE detected an error on page (44262:41495) in database "KBCLDBNEW" as read from the backup set. (Microsoft.SqlServer.Smo)

I have tried restoring in new database but still gives the error. I am cannot find the what is the problem. Thanks for helping me.

migrated from stackoverflow.com Sep 14 '13 at 8:05

This question came from our site for professional and enthusiast programmers.

  • 5
    "RESTORE detected an error on page (44262:41495)" - what's hard to understand? – Mitch Wheat Sep 14 '13 at 6:37
  • 4
    It means that you haven't tested your backup and restore strategy recently. – ta.speot.is Sep 14 '13 at 6:49
6

Try running RESTORE VERIFYONLY and see if you get more information about the failure.

You could also try running RESTORE with CONTINUE_AFTER_ERROR and then run DBCC CHECKDB:

RESTORE DATABASE database_name 
FROM backup_device WITH CONTINUE_AFTER_ERROR

(i.e. running as TSQL rather than through SMO)

DBCC CHECKDB(N'databasename') WITH EXTENDED_LOGICAL_CHECKS;

Specifying WITH CONTINUE_AFTER_ERROR in a RESTORE statement attempts to restore the database. However, there are many kinds of corruption that prevent recovering a database. We strongly recommend that you reserve using the CONTINUE_AFTER_ERROR option until you have exhausted all alternatives.

All backup strategies should include regular DBCC CHECKDB runs.

Also NOTE: You do not have a backup unless you periodically successfully test restores.

Responding to SQL Server Restore Errors Caused by Damaged Backups

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy