Database Backup Strategies in Support of High Availability

Backing up and restoring databases are fundamental to any highly available implementation. The real trick is in knowing what type of backup to do and how often to do it so that your database can be recovered easily and quickly to fulfill your high availability requirements. You have two things to protect: the integrity of the data and the availability of the data. Understanding how long it takes to back up your database or to restore your database should be well known as you plan for high availability. This must also correspond closely to the service level agreements you have committed to. Having the proper backup and recovery approach in place is key to achieving these commitments. Plan ...

Get Microsoft® SQL Server High Availability now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.