Markus (8/5/2014)
I backed up a production database from Data Center A, backed it up across the network and restored it to a SQL Server in Data Center B which is nonproduction. THe restore worked fine. However, a DBCC CHECKDB shows the below errors. If I run a DBCC CHECKDB on the DB in DataCenter A it says zero errors. The SQL Server in DataCenter A is SQL2008R2 SP1 and the one in DataCenter B is SQL2008R2 SP2. My question is that my Storage guys say there is no issues with the back end storage. I say that cannot be... He thinks we need to rule out the SQL Server binaries as the issue. I say this is data corruption. Thoughts?
That's data corruption. It may have happened during the restore, it may have happened during the copy. Try backing up WITH CHECKSUM and doing a verify on the backup before restoring it
I know that is a very minor checkdb routine that is run upon a db restore.
There is not. CheckDB runs only when it is explicitly run by someone or some job. There is never an automatic checkDB ever.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability