March 5, 2013 at 11:57 am
Hi ,
I hope to enable this Always On Availability group option the server must be in failover clustering. In our environment we have one sql server 2012 enterprise edition and two sql server 2008r2 standard edition. Is it possible to configure fail over between these nodes . Any option to enable Always On option in sql server 2012 . Kindly share your views. Need to make use of this option in sql server 2012 .
March 5, 2013 at 1:07 pm
Nope. AlwaysOn Availability Groups is a SQL Server 2012 functionality. The windows failover cluster can be Windows 2008 R2 sp1, however SQL versions cannot be mixed.
Cheers!
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 9, 2013 at 7:57 am
yeah we cannot do the always on feature on diffrenet version,
SQL always on feature which is the new in sql server 2012..
March 9, 2013 at 8:29 am
Just an additional comment, any form of HA/DR between SQL instances of different versions (log shipping, mirroring, etc) is generally not a good idea. The only way it can work is if the primary server is the lower version and the DR server is the higher version, but if you ever fail over to the DR server, you cannot fail back to the primary, which kinda defeats the point of a DR setup.
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
March 9, 2013 at 9:33 am
Yeah thats good tip for me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply