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 one too if there’s enough demand). It has a simple… Read more

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 the distribution of run-times on various kinds of hardware for various size databases. So, if you have a couple of minutes, I’d be… Read more

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 so I thought that would make a good topic for the next post… Read more

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 long did it take to run last… Read more

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 – single-page restore or manual insert/select –… Read more

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 I fly out to… Read more

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 lecture I did on DBCC… Read more

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 were challenging to say the least this morning… Read more