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.
Why does this happen? Am I right while doing this or is something missing?