Browse by Tags

• Backup
• DBCC CHECKDB Series
• Disaster Recovery
• Index Fragmentation Series
• On-Disk Structures
• Restore

• Example corrupt database to play with and some backup/restore things to try

  I've been asked several times over the last few weeks for an example corrupt database to play with, and for testing logic built around DBCC CHECKDB. The attached WinZip file contains a backup of a simple 2005 database called 'broken' (I can do a 2000 Read More... Posted Tuesday, April 17, 2007 10:22 AM by Paul Randal - MSFT | 10 Comments Filed under: DBCC, Disaster Recovery Attachment(s): broken.zip

• Oh no – my backup is corrupt too! Help!

  Funny how a bunch of people all seem to have the same problem at the same time. Maybe it’s just that people don’t want to talk about corruption until someone else does – it’s like a dark secret that once let out of the bag – everyone talks. The common Read More... Posted Monday, March 05, 2007 1:59 PM by Paul Randal - MSFT | 2 Comments Filed under: DBCC, Disaster Recovery, Backup, Restore

• How long does *your* CHECKDB take?

  Following on from my post a couple of weeks ago ( https://blogs.msdn.com/sqlserverstorageengine/archive/2007/01/24/how-long-will-checkdb-take-to-run.aspx ), I'm very interested to know how long it takes for your CHECKDBs to run, so I can get an idea of Read More... Posted Tuesday, February 13, 2007 4:29 AM by Paul Randal - MSFT | 4 Comments Filed under: 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

• CHECKDB (Part 7): How long will CHECKDB take to run?

  This is a question I see every so often and it cropped up again this morning so I'll use it as the subject for this week's blog post. There are several ways I could answer this: the unhelpful answer - I've got no idea. the almost-helpful answer - how Read More... Posted Wednesday, January 24, 2007 1:12 PM by Paul Randal - MSFT | 5 Comments Filed under: DBCC, Disaster Recovery, DBCC CHECKDB Series

• Fixing damaged pages using page restore or manual inserts

  Here's an interesting scenario that cropped up today. You have a database on a RAID array that failed and has zero'd out a page. How can you get the data back? There are two ways to do it, depending on the database recovery model and version of SQL Server Read More... Posted Thursday, January 18, 2007 12:02 AM by Paul Randal - MSFT | 8 Comments Filed under: DBCC, Disaster Recovery

• 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 | 11 Comments Filed under: DBCC, Index Fragmentation Series, On-Disk Structures

• CHECKDB (Part 6): Consistency checking options for a VLDB

  (Yippee - just finished my certification dives and got my PADI Open Water certification - just in time for our dive trip to Indonesia in December :-) This is a question that comes up a lot - in fact 3 times this week already - most recently during a guest Read More... Posted Friday, October 20, 2006 3:57 AM by Paul Randal - MSFT | 9 Comments Filed under: DBCC, Disaster Recovery, DBCC CHECKDB Series

• CHECKDB (Part 5): What does CHECKDB really do? (part 4 of 4)

  (Another airport, another blog post - I really must make an effort to come up with more original banter - I'm sure I've used that line before. TechEd Guangzhou has finished and I'm on the way to Beijing for TechEd #3. Checking in and getting through security Read More... Posted Wednesday, September 20, 2006 10:03 AM by Paul Randal - MSFT | 7 Comments Filed under: DBCC, DBCC CHECKDB Series

• CHECKDB (Part 4): What does CHECKDB really do? (part 3 of 4)

  (OK - I was wrong about the posting frequency - events overtook me and I got bogged down preparing for these TechEds. China is an amazing place and I wish I had more time to soak up some of its culture while I'm here but with the TechEds being so close Read More... Posted Monday, September 18, 2006 10:43 PM by Paul Randal - MSFT | 9 Comments Filed under: DBCC, DBCC CHECKDB Series

• 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

• Can't I ever get a guarantee?

  I've been sitting and thinking a lot about guarantees this morning while drinking coffee in the debilitating heat here (85 degrees at 11am) and things get more complicated the more I think about it, so time to stop and post some thoughts. Over the last Read More... Posted Sunday, July 23, 2006 7:19 PM by Paul Randal - MSFT | 3 Comments Filed under: DBCC, Disaster Recovery

• CHECKDB (Part 3): What does CHECKDB really do? (2 of 4)

  In the previous post of this series, I covered the system table checks that have to be done before anything else can be checked by CHECKDB. Now that I've described pages , extents , IAM chains/allocation units and the major allocation bitmaps , in this Read More... Posted Tuesday, July 18, 2006 11:16 PM by Paul Randal - MSFT | 3 Comments Filed under: DBCC, DBCC CHECKDB Series

• CHECKDB (Part 2): What does CHECKDB really do? (1 of 4)

  Hmmm - I sat for 5 minutes thinking of something amusing to say to start this one off and nothing came to mind, so I'm afraid this will be a humor-free post. Maybe I'm jet-lagged from being on the East coast all last week. As with all things related to Read More... Posted Monday, June 19, 2006 2:09 AM by Paul Randal - MSFT | 11 Comments Filed under: DBCC, DBCC CHECKDB Series