Paul Randal, he of SQLskills.com fame, has published a new whitepaper on High Availability with SQL Server. If you follow any SQL Server news or blog sites, you’ve probably already see the announcement for it, but I wanted to mention it here in case you haven’t seen it yet.
There are certain references I save so that when I need to make sure I cover the bases with someone on a topic or I get a question on “tell me everything there is to know about X”, I can send the link to folks so they can do their own research. This is one such link.
No, it doesn’t cover every single HA technology, and no, it isn’t an in-depth manual on how to set things up, nor would you have time to read something like that. This paper is a great way to introduce yourself to the concept of HA first, and then maps the technology to those topics second. It’s the way I like to think and write as well.
If you haven’t seen it yet, make sure you give it a read here: http://msdn.microsoft.com/en-us/library/ee523927.aspx