SQL Server Database Corruption Detect

• Grey Cat

  Mr or Mrs. 500

  Points: 524

  More actions

  June 19, 2018 at 12:02 am

  #355481

  Comments posted to this topic are about the item SQL Server Database Corruption Detect

• keeyu2

  Old Hand

  Points: 389

  More actions

  June 19, 2018 at 7:33 am

  #1994449

  Actually, I had a bad page on disk.  And CheckDB didn't detect the issue and when I restored the database it still shows the error.  I ended up loading the table from my AlwaysON secondary node to the primary node and dropping the original table.

• Grey Cat

  Mr or Mrs. 500

  Points: 524

  More actions

  June 19, 2018 at 9:37 am

  #1994468

  keeyu2 - Tuesday, June 19, 2018 7:33 AM

  Actually, I had a bad page on disk.  And CheckDB didn't detect the issue and when I restored the database it still shows the error.  I ended up loading the table from my AlwaysON secondary node to the primary node and dropping the original table.

  I am sorry to hear this. DBCC CHECKDB does not grantee finding all type of corruptions :(. 
  In your case, it probably had been there for a while since your backup was bad too.
  I was helping on a situation recently. Both primary and secondary were corrupted. End up with creating the DB from scratch. The only good thing was that the DB was still up and running so we could dump data.

  I guess we only can do as much as we can.