We migrate our database server from HP Superdome(IA64) to HP DL980 recently. I found I can't restore our backup on dl980 to a standby server(1U server made by my company, Quanta computer, and HP EVA 8100). The error message is "Msg 824, Level 16, State 2, Line 1 SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 20:5740344; actual 0:0). It occurred during a read of page (20:5740344) in database ID 5 at offset 0x00000af2e70000 in file 'l:\TCPDATA4\TCPDATA19.ndf'."
It failed many times on different backup(ex: 7/14, 7/20, 7/22, 7/24) and I suspect our production database is corrupted. I tried to restore several times and finally I found I could restore 8/2 backup without any errors. Very strange, isn't it? Anyways, I read one document before, I could run checkdb in standby server and found which table is corrupted.
I run dbcc checkdb with physical_only on production and no errors found. I ran checkalloc on standby and it finished without any errors. I run check all tables in parallel on standby and I found there are several consistency errors found in 16 tables. I run check tables in production system. However, I didn't find any errors in production database.
That's too weird. What's wrong in our system. Could someone explain this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.