Post reply

SQL Server Database Corruption Detect

  • June 19, 2018 at 12:02 am

    #355481

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

  • 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.

  • 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.

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

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