Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Unanswered: Upgrading SQL 7 Cluster TO SQL 2000 ?

    I am currently running an active/passive cluster NT4 with SQL7 clustered. I am trying to upgrade SQL to a clustered 2000 version. I have a san disk area allocated as a Z: drive. These are the following steps I have taken:
    1. Used cluster wizard to uncluster the SQL 7 instance.
    2. Using the SQL 2000 Enterprise cd created a new virtual server (with the same IP address and name as the previous SQL 7 server) I have left the install as a default instance.
    3. Part way through the install I am asked to browse to the data area. The data area is Z:\mssql7\data.
    On completion of the install I now have the following data path Z:\mssql7\data\mssql\data and all the databases are still SQL7 databases.
    My questions are:

    How can I get the install to update/convert the databases to SQL 2000 as it doesnt seem to recognise them?

    Will the install always suffix the data path with mssql\data

    Any assistance appreciated.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    I would suggest this cluster article to upgrade from 7 to 2000.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •