This is the blog of the engineering team managing and developing the Database Engine for SQL Server and Azure SQL Database
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