Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL Server 2012 HA on Server 2008 R2 vs. Server 2012 Expand / Collapse
Posted Thursday, May 16, 2013 10:10 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, February 18, 2015 4:27 PM
Points: 50, Visits: 165
I am planning for the update from SQL Server 2008 R2 to SQL Server 2012. I've read some accounts of differences between running Always On and WSFC on the older version of the OS vs. the newer.

NB: I *am* trying to get a comment on this directly from Microsoft, but they're not being responsive so far. I am alo taking a Microsoft training course that purports to cover HA, but the references are superficial re this question.

The concerns revolve around updates to the database(s) on the servers in an Always On Availability Group.

Are there substantial differences between the steps to patch SQL Server 2012 running on multiple machines supporting multiple DB's when it's running on Server 2008 vs. Server 2012?

Our primary enterprise application, which would *definitely* be in an Availability Group, gets 4 business critical updates a year. Two of those are often taken under operating season pressures such that I don't want to add complexity that could be avoided. Are there substantial differences between the steps required to install and promulgate a new DB version under different versions of the server OS?

Note that, in all cases, the Availability Group will host at least two databases, but that only one of them will require major updates.

Does anyone have enough hands on experience with AlWays On and WSFC to venture ideas? Any suggestions on where (official Microsoft?) sites/blogs/????) I might try for an authoritative answer?

Post #1453654
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse