May 7, 2014 at 12:47 am
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 🙂
May 7, 2014 at 3:35 am
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" 😉
May 7, 2014 at 11:52 pm
Thanks for that. It was what i was expecting but haven't found anything in the documentation.
Cheers.
May 8, 2014 at 12:09 am
No, it should be detailed under backup\restore databases. You cannot move down versions, only upwards
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 8, 2014 at 7:30 am
Found it. The "Compatibility Support" section of this link details the following
RESTORE (Transact-SQL)
NoteNo SQL Server backup be restored to an earlier version of SQL Server than the version on which the backup was created.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply