SQL Server Performance

Upgrading a SQL Server 2000 cluster (Active/Passive) to a SQL Server 2005 Cluster

Discussion in 'SQL Server 2005 Clustering' started by cyberstrike, Dec 28, 2007.

  1. cyberstrike New Member

    We're upgrading a SQL Server 2000 cluster (Active/Passive) running on Windows 2000 Server to a SQL Server 2005 Cluster running on Windows Server 2003. We can't purchase new hardware and we have no spare hardware. We also need to move from Windows 2000 Server to Windows 2003 Server at the same time. We want to keep downtime to a bare minimum.
    What we were thinking was the following steps... Anyone try this?
    1. Break the link between the servers.
    2. Install a fresh copy of windows 2003 server on one side along with SQL Server 2005. While this step is running, the active node would still be live on Windows 2000 Server and SQL Server 2000 serving our customers.
    3. Restore a copy of a backup from the active production side to the node we're upgrading and at that point we would bring the active node down, switching the active node to be the newly upgraded server.
    4. As a final step, the old active node would now have the link to it broken, we would install a fresh copy of windows 2003 server on it and sql server 2005. At this point we would bring it back into the cluster and the cluster would be complete again.
    Thoughts?
  2. satya Moderator

    The main concern is disturibing the current hardware & setup, keeping the downtime to minimum may not be entierly possible as the process not tested. Always better to check HCL (compatibility list) for this SQL 2005 configuration to avoid new surprises with this upgrade.
    The steps sounds good on that basis of whether you have tested them elsewhere to get acquaintance. Below are the links that could help you to plan further on process:
    http://www.sql-server-performance.com/articles/clustering/upgrade_current_cluster_p1.aspx
    http://msdn2.microsoft.com/en-us/library/ms191009.aspx
    http://yukonspace.blogspot.com/2007/10/sql-server-2005-upgrade.html
    http://sqlserver-qa.net/blogs/tools...g-cluster-sql-server-choices-and-options.aspx
  3. MohammedU New Member

    It is very risky upgrade and not advisable but when there is no option and you guys know the consequences then you can proceed...
    If you are on cluster means you might be using SAN? If yes then you don't need to restore the backups because you can detach the databases from active node and attched the SAN to newly installed server and then attach the databases instead of restoring them which is much faster.
    You can't attach or restore system databases so you can script jobs/alerts etc to create them in 2005 and script the logins too and create them in 2005.
    Good luck...

Share This Page