Comments (17)

  1. Thanks to Paul Randal for pointing out my math error. The PFS repeats every 64 MB, not every 1/2 GB. Corrected in this post and in the tempdb contention post.

  2. Hi Davis, thanks for sharing your tech, very very very nice post. please keep up the good work. I’m waitting for your next post, yeah !

  3. […] Continue reading here: Day 6 of 31 Days of Disaster Recovery: Dealing With Corruption in … […]

  4. […] Dealing With Corruption in Allocation Pages […]

  5. […] Recovery series. I’ve previously discussed handling corruption for nonclustered indexes and allocation pages. Today, I’m going to talk about a specific corruption that is very simple to fix; however, it […]

  6. Hi Davis …

    Great post .. Thanks for sharing ..

    Even i had trouble finding out … after how many pages does PFS reappears
    1/2 GB or 64 MB …

    Thanks Again

    1. Thanks Gurpreet. I did know the right value up front because I learned it from Paul Randal to start with. Just had a brain lapse for a minute when writing it. 🙂

  7. […]         http://www.sqlsoldier.com/wp/sqlserver/day6of31daysofdisasterrecoverydealingwithcorruptioninallocati… […]

Leave a Reply to Day 23 of 31 Days of Disaster Recovery: Restoring Differential Backups With New Files | SQLSoldierCancel reply