Sql Server Backup and Recovery [Paperback]

I've become accustomed to a wide variety of lame backup and recovery books. A good example is Anil Desai's... long on planning, but short on how to actually do the work. In his book, backups don't actually start till chapter 6! Easily 2/3 of the book is fluff.

For example, Desai talks about log shipping-- 5 pages. McBath has a whole chapter on it in a how-to format. BOL doesn't cover it in depth, and where it does, it's wrong (ie. sp_change_primary_role example is wrong on fail over). SQL Server Resource Kit has a whole chapter on it, but not one example of how to implement. Long on theory, short on getting it done-- typical of MS Press books.

The book covers just about all the methods for backing up and recovery using standard tools. It also covers using DBCC to recovery data. Then it expands out into rebuilding your stuff from scratch and reloading it (ex. I lost my master database and here's what I got to do).

McBath's book tells you what breaks along the way and how to fix it. Anyone who's had to rebuild master and got in that infinite loop problem knows the hard way. McBath tells you about the problem *BEFORE* you hit it and how to work around it. The Desai book doesn't even tell you how to properly bring the SQL Server into single user.

This is also the only book out there... including Delaney's... that actually flow charts the sequence of events on how a backup and recovery actually work internally. LSN's, GAM Pages, etc... That way you get the theory as well as the practical I-got-to-get-my-job-done stuff.

The section on DBCCs is the first place I've seen where it's pretty much explained well. Delaney's book is also great here, but McBath put's it in context for recovery of data. The straight dope is here. It's dialed in right.

Another interesting point was he shows you the output of the scripts. That way you can see what it's supposed to do *BEFORE* you do it on your box. By doing this, he's also showing you that the scripts have been tested and run, too.

What I liked most was that it used the GUI and T-SQL scripts. This is great cause most people use a GUI which you can't script in SQL Agent, etc...

What's also cool is the Mohan/Narang paper as the appendix. Mohan outlined the ARIES Write Ahead Log (WAL) protocol recovery mechanism that SQL Server is premised upon. I wish there was more intro to it here. It's just tacked on the back. But this is just gold.

Stuff missing that would be cool: Covering third party tools like Legato. In a major data center, they are mandatory.

Finally a book for SQL Server that rivals Oracle Press's long standing tome on Backup and Recovery by Velpuri.

McBath's book is non-stop backup and recovery issues from beginning to end.

What I liked most was that it describes using the GUI and T-SQL scripts. A GUI is nice but to really
hit the nail one should automate this and script it.
This is THE Backup/Restore book each SQL-Server DBA must have in his bag. READ it BEFORE disasater
happens. One can never be preperaed enough for situations like this.

Last but not least there's an appendix with the Mohan/Narang paper This paper outlines
the ARIES Write Ahead Log protocol recovery mechanism that SQL Server uses.