question

Col avatar image
Col asked

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?
sqlfailoverstandby
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM commented ·
What version of SQL Server?
0 Likes 0 ·
Col avatar image Col commented ·
Sorry... its sql 2012 on windows 2012,SQL Version is 2012
0 Likes 0 ·

1 Answer

·
JohnM avatar image
JohnM answered
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. https://blogs.technet.microsoft.com/volume-licensing/2013/08/22/licensing-how-to-sql-server-fail-over-vs-cold-disaster-recovery-rights/ 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!
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.