Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dance Doll
Yak Posting Veteran
54 Posts |
 Posted - 2006-12-07 : 17:24:20
|
| We have SQL 2000 cluster servers. Now I want to upgrade to SQL 2005. My plan is installing SQL 2005 side by side to the same cluster servers. Later on, I will migrate the data from 2000 to 2005.Is there a better option to upgrade?And anything I need to concern about here?Thanks! |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-12-07 : 23:54:45
|
| yes your approach is pretty gud,just consider these things:1)If you are running a 32-bit OS on x86 hardware based cluster, you can install SQL 2005 32-bit edition side-by-side with SQL 2000 32-bit edition. Again, you must install SP3 or above for SQL 2000. To the above cluster, you cannot add another node which is running on x64 hardware. This is not supported. 2)If you are running a x64 hardware with x64-bit OS based cluster You can install SQL 2005 x64-bit edition with SQL 2000 32-bit edition with SP4You can install SQL 2005 32-bit edition with SQL 2005 x64-bit edition 3)For an IA64 hardware based cluster running IA64 bit OS, you can only install SQL 2005 IA64-bit edition with SQL 2000 IA64-bit edition. and plan as:1. Install SQL Server 2005 side by side with SQL Server 2000 cluster instances.2. Migrate data from SQL Server 2000 and SQL Server 2005 cluster instances.3. Make sure both SQL Server 2000 and SQL Server 2005 work correctly and expectedly.4. If you dont need SQL Server 2000 and you are sure SQL Server 2005 works well, then you can uninstall SQL Server 2000.its me monty |
 |
|
|
Dance Doll
Yak Posting Veteran
54 Posts |
Posted - 2006-12-08 : 11:10:06
|
| Well said, monty.I appreciate it! We curently only have one instance in SQL 2000. I want to create another one to 2000. Then use replication to mirror the new instance in SQL 2005. We'll see and run them for a while. If everything is fine, we will get rid of 2000. Now, I have more concerns on multiple instances in cluster servers. Does cluster server can take care of the multiple instances?Thanks! |
|
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-12-09 : 07:55:27
|
| Hi,You can run only one instance of SQL Server for each virtual server on a SQL Server failover cluster. However, you can install up to 16 SQL virtual servers on a failover cluster. The instance of SQL Server can be either a default instance or a named instance.When applications connect to the virtual server, they use the same convention as when they connect to any instance of SQL Server. They specify the virtual server name of the cluster and the optional instance name (only needed for named instances): virtualservername\instancename.When SQL Server is installed to a cluster, only one default instance of SQL Server is permitted. This default instance could be one of the clustered instances of SQL Server or a locally installed SQL Server version on either node.its me monty |
|
|
|
|
|
|
|
|
install SQL 2005 to a Cluster Server