SQL Server Database Corruption Detect

  • Grey Cat

    Mr or Mrs. 500

    Points: 514

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

  • keeyu2

    Old Hand

    Points: 389

    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: 514

    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.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply