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.