SQL Failover using standby server

I have been asked to provide a solution for failover using just 2 servers (Primary and a Standby), 1 sql licence and san for storage. Just want to know what my options are with this setup as we cannot use local storage and the DR server is only a standby?

more ▼

asked Apr 20, 2017 at 08:27 AM in Default

avatar image


What version of SQL Server?

Apr 20, 2017 at 12:28 PM JohnM

Sorry... its sql 2012 on windows 2012,SQL Version is 2012

Apr 20, 2017 at 12:37 PM Col
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

There are a couple of options depending on your needs. Each one would offer different levels of RPO/RTO so I would evaluate them to ensure they meet your business needs.

  1. Mirroring without a witness. This would not be an automatic failover.

  2. Traditional clustering (Active/Passive). This would be an automatic failover.

  3. Availability groups with a non-readable secondary.

  4. Log shipping. This would not be an automatic failover.

I believe these can be implemented with a single license as long as the secondary (DR) isn't been used for any production processing, IE: reporting or active workloads. However, I would definitely want to confirm that with your licensing vendor. They would have the resources to double check that. If you do have to fail over, however, you might have to move licenses around in order to be compliant.

Also consider having software assurance for the licensing. This, I think, would give you the best options as per the article below.


Also, keep in mind that you will actually license for the latest version so I would recommend looking at 2016 instead of 2012.

Hope that helps!

more ▼

answered Apr 20, 2017 at 02:03 PM

avatar image

14.4k 3 7 15

(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: Apr 20, 2017 at 08:27 AM

Seen: 72 times

Last Updated: Apr 20, 2017 at 02:03 PM

Copyright 2018 Redgate Software. Privacy Policy