Post reply

dbcc to recover corrupt pages

  • July 5, 2011 at 10:34 pm

    #243494

    [font="Tahoma"][font="Times New Roman"]

    hi,

    is there any DBCC to recover few corrupt pages from a table?

    [/font][/font]

  • July 6, 2011 at 1:22 am

    #1348774

    No. Corrupt means unreadable, damaged, useless. DBCC CheckDB will deallocate those pages. There's no way to recover something that's been overwritten with garbage (common corruption)

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 6, 2011 at 1:52 am

    #1348783

    [font="Times New Roman"]

    Can you please explain what happens when we execute DBCC CHECKDB?

    Regards,

    Anil

    [/font]

  • July 6, 2011 at 1:59 am

    #1348785

    http://www.sqlskills.com/blogs/paul/category/CHECKDB-From-Every-Angle.aspx

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 13, 2011 at 5:28 am

    #1380506

    Thank you for the link it was so valuable.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • September 13, 2011 at 5:30 am

    #1380511

    Any way to do a page restore from and older backup + all log backups?

  • September 13, 2011 at 5:39 am

    #1380523

    Ninja's_RGR'us (9/13/2011)

    Any way to do a page restore from and older backup + all log backups?

    Yes.

    http://msdn.microsoft.com/en-us/library/ms175168.aspx

    Google down in your neck of the woods?

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 13, 2011 at 5:41 am

    #1380524

    GilaMonster (9/13/2011)

    Ninja's_RGR'us (9/13/2011)

    Any way to do a page restore from and older backup + all log backups?

    Yes.

    http://msdn.microsoft.com/en-us/library/ms175168.aspx

    Google down in your neck of the woods?

    Sorry to interrupt, but this was not suggested in the thread so I proposed something that could solve a problem 😉

Viewing 8 posts - 1 through 7 (of 7 total)

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