Browse by Tags

• DBCC
• DBCC CHECKDB 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

• 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

• 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