April 18, 2017 at 10:34 am
Can Always on be configured between SQL 2014 RTM on Node 1 and SQL 2014 SP2 node 2. so here the SQL patch levels are different.
April 22, 2017 at 6:03 am
As per my perception it can be configured , as per Microsoft msdn Each server instance must be running the Enterprise Edition of SQL Server 2014 and it does not tell anything about product level of Instances. I cant say it firmly as didn't see such scenario practically. But it is always recommended to have latest update , why you want to keep one node SQL 2014 RTM and another one SQL 2014 SP2?
you may refer below link for always on prerequisits -
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
May 5, 2017 at 7:16 am
psred - Tuesday, April 18, 2017 10:34 AMCan Always on be configured between SQL 2014 RTM on Node 1 and SQL 2014 SP2 node 2. so here the SQL patch levels are different.
You know what I've never actually tried it and not sure I'd want to , espaecially as in some relaeses there were bugs with AO groups.
Not wise, make sure they're all same patch level
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply