When is too much success a bad thing?

I was talking to a customer the other day who had an interesting problem:  Successful backups. Specifically, their problem had to do with the success messages that SQL backup puts in the SQL errorlog and the system event log. Seems like a nice, friendly thing to do right?  Drop a note that your backup was… Read more

Fuzzy backups and RESTORE DATABASE WITH STOPAT

So what’s a “fuzzy backup” and how does it relate to STOPAT?   There has been some confusion about what RESTORE DATABASE WITH STOPAT does, if it works, and why it behaves as it does.  This is not about RESTORE LOG WITH STOPAT, but only RESTORE DATABASE.  To understand how this works and why, you… Read more

TechEd session video available…

The session I gave at TechEd this year on ‘Secrets of Fast Detection and Recovery from Database Corruptions’ was videotaped as part of the Its Showtime! TechEd program. The video is now available to watch at http://www.microsoft.com/emea/itsshowtime/sessionh.aspx?videoid=549. This is the same session I’ve been delivering to user groups around the world for the past few months but… Read more

SQL Server’s ‘black-box’ flight recorder

So I learned something about SQL Server at TechEd today. In Kimberly and Bob Beauchemin’s pre-con, Kimberly mentioned that SQL Server has a ‘black-box’ trace, similar to an aircraft flight-recorder, which I’d never heard of. It’s an internal trace that has the last 5MB of various trace events and it’s dumped to a file when… Read more

The Ins and Outs of Offline Files

First blog post of the year from TechEd! Well, Kimberly and I arrived a day early hoping to chill out in the sun by the pool but contrary to all expectations the weather sucks today – it’s actually much better in Seattle. Instead we’re hibernating in our room blogging and having a Blokus re-match – last time we… Read more

And an example corrupt 2000 database to play with

As promised in my earlier post of an example corrupt 2005 database, here’s one I’ve just created for SQL Server 2000. The attached WinZip file contains a backup of a simple 2000 database called ‘broken’ . It has a simple table called ‘brokentable’ (c1 int, c2 varchar(7000)) with one row in it. The table has… Read more

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

More on Service Level Agreements…

My recent post on SLAs prompted some interest and comments from readers so this is a follow-up to that post. What most people wanted was a list of some SLAs applicable to SQL Server – easier-said-than-done because a lot of SLAs depend on the application being serviced by the database. I had a poke about the… Read more

What are SLAs and why are they important?

(In the UK now hanging out with Kimberly and Tony Rogerson before teaching a Masterclass tomorrow in Reading. Then it’s off to Copenhagen for SQL Server Open World, with a little R&R in London beforehand and Copenhagen afterwards, before we fly back to the US on Sunday. The weather here is actually better than in Seattle!) I’ve had… Read more