We have SQL Server 7.0, running on Windows NT 4.0. We are in the process of building a SQL Server 2000 on a Windows 2000 machine. We will be running the SQL Server 2000 in a different branch. But we are planning to test the SQL Server 2000 on the same site. We will also move one database from SQL Server 7.0 to SQL Server 2000. Is it possible to do this? What precautions do we have to take? The SQL Sever 7.0 is running 6 days a week 24 hours a day right now.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
running SQL Server 7.0 and SQL Server 2000 Simultaneously
- Thread starter shaminda
- Start date
Hi,
You may have sql 7 and 2000 on the same machine. For this you must install sql7 first, after that a named instance of sql2000 (attention, it must be a named instance of sql2000 not the default one, if you leave default it will replace the sql7). If you make so you may have both sql7 and sql2000 running in the same time. Alternatively if you need you may install sql6.5, sql7,sql2000. In this scenario only these combinations are possible: sql6.5 +sql2000 or sql7 +sql2000 running in the same time
You may have sql 7 and 2000 on the same machine. For this you must install sql7 first, after that a named instance of sql2000 (attention, it must be a named instance of sql2000 not the default one, if you leave default it will replace the sql7). If you make so you may have both sql7 and sql2000 running in the same time. Alternatively if you need you may install sql6.5, sql7,sql2000. In this scenario only these combinations are possible: sql6.5 +sql2000 or sql7 +sql2000 running in the same time
- Status
Similar threads
- Locked
- Question
- Locked
- Question
