none
Mirroring 2016(sp2) RRS feed

  • Question

  • Sign in to votehi

    In environment  2 DC server in  Failover clustering ( sqlserver2016(sp2) Enterprises edition)  and 1DR server standalone sqlserver2016(sp2) Standard edition, I want to mirroring in DC - DR .Is it possible to mirroring??

    ajit kumar 


    ajitkumar

    Friday, September 6, 2019 4:48 AM

All replies

  • This is not supported and dangerous. Early versions of SQL Server allowed this (unsupported) setup. Not sure if it is still the case with 2016 but I would strongly suggest against it. I would also suggest not to use mirroring with new SQL Server versions because it is deprecated feature. You would not get any fixes if something goes wrong.

    In your case, the best option would be upgrade your DR server to Enterprise and use Availability Groups.


    Thank you!

    Dmitri V. Korotkevitch (MVP, MCM, MCPD)

    My blog: http://aboutsqlserver.com

    Friday, September 6, 2019 2:50 PM