SQLTeam.com | Weblogs | Forums

AlwaysOn or Database Mirroring for High Availability?

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

hi

please see if the following link helps !!!

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?

sorry jbates99
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 !!!