Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

migrated from Sep 14 '13 at 8:05

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

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

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 

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


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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.