I know Microsoft says Database Mirroring will be deprecated in a future release. It's so reliable and is used by so many installations, I think it may be kept for a long while.
Which is the better option when using SQL Server 2014? AlwaysOn or SQL Server Mirroring?
Thanks for your opinions
please see if the following link helps !!!
Back in December 2016, I talked about the same in my post Explaining High Availability and Disaster Recovery. In this post today, I am going to explain two main Advantages of using Always On instead Mirroring.
Thanks harishgg1. This is SQL Server 2014 on Windows Server 2012, already in production use. 2014 as you know does not support Basic Availability Groups. Can I configure Always On 2014 with only 2 SQL Servers, a primary and a secondary?
i have no idea
experts on this forum will help you
i am not a SQL database admin
Have to go thorough the Manual Docs from Microsoft
Or google Search
FOR key terms ..Can I configure Always On 2014 with only 2 SQL Servers, a primary and a secondary?
Dont have any experience in it !!!