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
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 HA/DR issue over the last… Read more
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
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
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
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
(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
(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
(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
(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 together there’s little time… Read more