slim.richard (5/7/2014)
Hi all,Is it possible to have a 2014 Availability Group with a read-only secondary Replica in SQL 2012. The replica will never be failed over to or written to, just used as a readable replica.
Thanks in advance 🙂
No, you cannot replicate down versions. You could have a 2012 AO group with a 2014 replica, this would be used for migration purposes.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉