Call Before You Dig—Scenario #4 with Log Shipping
As you saw in Chapter 3, “Choosing High Availability,” the call before you dig business scenario (scenario #4) combined hardware redundancy, shared disk RAID arrays, MSCS, SQL clustering, and log shipping. This is a very critical system during its planned hours of operation, but has low performance goals, and low cost of downtime (when it is down). Regardless, it is highly desirable for this system to be up and running as much as possible. Having that warm standby with log shipping provides just enough of an insurance policy in case the whole SQL cluster configuration fails. After building this HA solution, the uptime goal was achieved easily. In fact, after three months, the log shipping configuration ...
Get Microsoft® SQL Server High Availability 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.
