Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Upgrade sql 2005 to sql 2008r2

Answered Upgrade sql 2005 to sql 2008r2

  • Saturday, August 11, 2012 1:22 AM
     
     
    Sign In to Vote
    0

    Hello,

    I need to upgrade my current instance of sql 2005 to sql 2008r2.  Here is my current setup:

    We have two windows 2003 servers in a clustered environment.  Each node has sql 2005 installed on it and is participating in the fail over  cluster. 

    I have two new servers with Windows 2003 server installed that i want to use to replace the existing ones.  I would like to add the two new servers as nodes in the current cluster using the sql 2008r2 installation disk.  Then, over time, i will evict the old servers.

    Is this possible?  Can I add a sql 2008r2 node to a sql 2005 cluster?  If not, what is the best way to do this?  

     

All Replies

  • Saturday, August 11, 2012 6:21 AM
     
     Answered
    Sign In to Vote
    0

    Hi!

    I am not sure if your scenario is supported, but there is one that would be: Rolling upgrade... What you would have to do is install SQL 2005 on those new boxes and then upgrade those inplace to 2008R2. The thing with this is though that after your first failover to one of the upgraded instances your old 2005 installations instantly become useless as they can no longer read the database files...

    Lucifer