How to upgrade from a SQL Server 6.5 active/active failover cluster (Setup)

How to Install SQL Server 2000

How To

How to upgrade from a SQL Server 6.5 active/active failover cluster (Setup)

Note  To upgrade from a Microsoft® SQL Server™ 6.5 active/active failover cluster (or any configuration where SQL Server exists on the second node), you must first convert one side of the failover cluster to a named instance of SQL Server 2000.

To upgrade from a SQL Server 6.5 active/active failover cluster

  1. On Node 1, uncluster SQL Server 6.5. On Node 2, uncluster SQL Server 6.5.

  2. On Node 1, install a default (non-clustered) instance of SQL Server 2000.

    You must install the binaries to a local drive and use a cluster disk for the data. This local drive is a path, which is a non-clustered disk valid on all nodes of the cluster. This drive on all nodes of the cluster must have at least 300 megabytes (MB) of available space.

  3. On Node 1, run the SQL Server 2000 Upgrade Wizard to migrate your data into SQL Server 2000.

  4. On Node 1, uninstall the instance of SQL Server 6.5.

  5. On Node1, install a named, clustered instance of SQL Server 2000.

  6. Run the Copy Database Wizard (CDW.exe) to migrate your SQL Server data (originally from SQL Server 6.5) to a named instance in a SQL Server 2000 failover cluster. For more information about the Copy Database Wizard, see Using the Copy Database Wizard or How to upgrade databases online using the Copy Database Wizard (Enterprise Manager).

  7. On Node 1, uninstall the default instance of SQL Server 2000.

  8. On Node 2, install a default instance of SQL Server 2000.

  9. Run the SQL Server 2000 Upgrade Wizard to migrate your data into SQL Server 2000.

    You must install the binaries to a local drive and use a cluster disk for the data. This local drive is a path, which is a non-clustered disk valid on all nodes of the cluster. On all nodes of the cluster, this drive must have at least 300 megabytes (MB) of available space.

  10. On Node 2, uninstall the instance of SQL Server 6.5.

  11. On Node 2, upgrade the default instance of SQL Server to a clustered instance.

    For more information, see How to upgrade from a default instance to a default clustered instance of SQL Server 2000 (SQL Server Setup).