Browse by Tags

• DBCC CHECKDB Series
• Disaster Recovery
• Index Fragmentation Series

• CHECKDB (Part 8): Can repair fix everything?

  I was teaching at a Microsoft-internal class last week and there was a discussion on what corruptions can't be repaired using DBCC. At the same time, several threads popped up on forums and newsgroups with people hitting some of this unrepairable corruptions Read More... Posted Sunday, February 04, 2007 4:53 PM by Paul Randal - MSFT | 3 Comments Filed under: DBCC, Disaster Recovery, DBCC CHECKDB Series, On-Disk Structures

• More undocumented fun: DBCC IND, DBCC PAGE, and off-row columns

  (Final blog post of the year for me. Its been a bit of a wild ride the last 6 months - 7 TechEds on 3 continents, 46 blog posts and some major life changes - but now things have calmed down and I should be back to more regular posting in 2007. Tomorrow Read More... Posted Wednesday, December 13, 2006 10:46 PM by Paul Randal - MSFT | 13 Comments Filed under: DBCC, Index Fragmentation Series, On-Disk Structures

• Don't try this at home kids... (data recovery using DBCC PAGE)

  Time to cough up a real-life data recovery scenario to temporarily stop those people who badger me relentlessly for scenarios... We have a situation currently with a customer who managed to delete all their data during a SAN reconfig and then found out Read More... Posted Wednesday, August 09, 2006 8:41 PM by Paul Randal - MSFT | 5 Comments Filed under: DBCC, Disaster Recovery, On-Disk Structures

• Poking about with DBCC PAGE (Part 1 of ?)

  (It's been a while since I last posted - summer fun's been in the way obviously and I've been busy picking up some new and exciting (for me) SQL skills, partially to help with four upcoming TechEds I'll be doing in China and Hong Kong. The posting frequency Read More... Posted Wednesday, August 09, 2006 2:52 AM by Paul Randal - MSFT | 6 Comments Filed under: DBCC, On-Disk Structures Attachment(s): Data.zip

• How to use DBCC PAGE

  Yes, finally I come clean and tell all. It's an open secret that there's an undocumented DBCC command called DBCC PAGE that you can use to look at the contents of database pages. I've recommended in forum postings that people use it and Product Support Read More... Posted Saturday, June 10, 2006 7:14 PM by Paul Randal - MSFT | 9 Comments Filed under: DBCC, Disaster Recovery, On-Disk Structures