Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Wednesday, October 31, 2012 6:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 6:51 AM
Points: 125, Visits: 516
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