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.