SQL Server DBA

High availability and disaster recovery

Question

Failover cluster instance versus log shipping: what protection differs, and when should each be used?

Answer

An FCI protects an instance through shared storage and local cluster failover. Log shipping maintains restoreable copies on separate storage and servers. Use FCI for local instance availability; use log shipping for simple, geographically separate DR.

This is 6 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples