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
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
add comment

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

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

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.