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

Upgrading a sql server 2005 clustered environment to sql server 2008 R2 Expand / Collapse
Posted Wednesday, October 31, 2012 6:40 AM


Group: General Forum Members
Last Login: Monday, October 19, 2015 11:10 AM
Points: 128, Visits: 561
I'm trying to determine the best approach(i.e. in-place or clean install) to upgrade our sql server 2005 clustered environment to sql server 2008 R2). If you do an in-place install and your not running the latest service pack for sql server 2005 will it still do the upgrade to sql server 2008 R2 or will it expect
the service packs to be installed first. My understanding is that you upgrade the passive node first.
If the upgrade on the passive node is not successful, can the active node which is still running sql server 2005 be my fallback plan?

Thanks in Advance.
Post #1379283
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse