CHAPTER 9

image

High Availability and Disaster Recovery

Up until now, I have been talking thus far about the health and well-being of your SQL Server infrastructure and how to maintain and monitor it. However, there’s a time you hope never comes, but it is inevitable, and it’s a reality you must prepare for. Let’s cover what happens in the case of SQL Server sickness, that is, if your SQL Server instances crash and fail. If disaster strikes, whether the event is natural, technical, or man-made, how will you respond, and how will your organization recover? Can you ensure business continuity in the face of disaster? High availability and disaster recovery ...

Get Healthy SQL : A Comprehensive Guide to Healthy SQL Server Performance now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.