• There's a whole section in BOL on high availability that covers the ways SQL Server handles this.