Take the 2-minute tour ×
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. It's 100% free, no registration required.

I have a backup of database version sql server 2008 R2 . while restoring it to SQL Server 2012 I am getting error

msg 3183 RESTORE detected an error on page (6100:1886858449) in database ... .

While restoring the same file on another instance of 2008 R2 , it is being restored successfully. I performed DBCC CHECKDB(DB NAME) and then taken the manual backup and using this backup file , I restored the file . It got restored successfully.

I want to know why does this happen. Am I right while doing this or something is missing.

Please help me out.

Thanks,

Nitesh Kumar

share|improve this question

migrated from stackoverflow.com Nov 11 '13 at 16:35

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

2  
Any chance that you are trying to restore the backup from a n/w share ? Also, best is to use CHECKSUM when you take backups. Seems problem with the hardware - Disk ? –  Kin Nov 11 '13 at 16:41
    
Verify good functioning of the storage subsystem. –  Jon Seigel Nov 11 '13 at 17:41

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.