March 31, 2015 at 12:39 pm
SInce they do not want to upgrade the current DWS servers. questions is:
Can I have the primary replica in SQL 2008 R2 EE, and the other secondary replicas in SQL 2012?.
Appreciate your help.
April 1, 2015 at 4:17 am
Pablo Campanini-336244 (3/31/2015)
SInce they do not want to upgrade the current DWS servers. questions is:Can I have the primary replica in SQL 2008 R2 EE, and the other secondary replicas in SQL 2012?.
Appreciate your help.
Always on groups are SQL server 2012 Enterprise edition feature, not available in SQL Server 2008 R2!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 1, 2015 at 4:22 am
The only time that mirroring or availability groups with mis-matched versions are supported are for rolling upgrade scenarios.
If you were to set up mirroring with the SQL 2008 R2 server as the principal and the 2012 as the mirror (mirroring, since availability groups were added in SQL 2012), then you'd have a high availability solution which does not provide high availability, so kinda defeating the point.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 1, 2015 at 6:30 am
Got it, Appreciate your help......:-)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply