Pros and cons of HA solutions

What are the pros and cons of using the various high availability solutions for SQL Server? I know of

  • clustering
  • database mirroring
  • replication
  • log shipping

Are there other choices?

more ▼

asked Oct 16, 2009 at 08:49 PM in Default

avatar image

Steve Jones - Editor ♦♦
5.2k 79 94 87

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Clustering is the most expensive, requiring special hardware and a shared disk. Failover for clustering is at the Server Level.

Mirroring, (In High Availability (Synchronous)) will also support automatic failover - however this is at the database level and not the server level.

Log Shipping will ship or send the log files to a warm standby server that could be brought online in the event that the primary server failed - though this would be a manual failover (or custom code) and not an automatic failover. Replication is similar to Log shipping, where the data from the publishing database is sent over to the subscriber.

Clustering and Mirroring, give the benefit of automatic failover, but the failover databases are not accessible. Log Shipping and Replication would allow you to scale out and utilize the secondary databases for read only queries or reporting, but don't natively support automatic failover.

Two articles where the comparison is detailed much more than the high level generalization I posted would be:


(Take note of the OP as well as the author of the above article ....)



more ▼

answered Oct 16, 2009 at 11:13 PM

avatar image

Jay Bonk
1.4k 2 4

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 16, 2009 at 08:49 PM

Seen: 4203 times

Last Updated: Oct 17, 2009 at 07:27 AM

Copyright 2018 Redgate Software. Privacy Policy