SQL Server 2008 R2 100% availability
- by Mark Henderson
Is there any way to provide 100% uptime on SQL Server 2008 R2?
From my experience, the downtimes for the different replication methods are:
Log Shipping: Lots (for DR only)
Mirroring w. NLB: ~ 45 seconds
Clustering: ~ 5-15 seconds
And all of these solutions involve all of the connections being dropped from the source, so if the downtime is too…