Tuesday, March 27, 2012

Cluster setup

We are on SQL Server 2000 A/A cluster and are moving to SQL Server 2005 cluster.

Following are the list of things before proceeding, please let me know if it needs any corrections and add-ons:

(side-by-side) Planning for new installation of SQL Server 2005 ( SQL2005INST1 and SQL2005INST2) on node1 and node2 and restoring the databases on SQL2005INST1 and SQL2005INST2 from respective 2000 instances.

1) SQL2005INST1

SQL Network Name

SQL IP address

2) SQL2005INST2

SQL Network Name

SQL IP address

As 2000 is already existing on the cluster.Want some clarity on following questions.

Can I keep the data files on the same disk as 2000 was using ?

Do I need to have new disk for the Quoram drive?

Under "Virtual Server Configuration" wizard during the setup under "Network to use" for "private cluster network" and "public cluster network" do that IP Address and network address and network subnet will be different from what we gave for SQL 2000.

Thanks

ITTECH

1. For eachc cluster instance, you need separate physically shared disk and IP address.

2. If you have enough physical disks and IP addresses, then you can install SQL Server 2005 on the cluster side by side with SQL Server 2000 without affecting SQL Server 2000.

3. IP address may not be in the same subnet, but it should not be already used by any other application. Otherwise, setup will complain that the IP address is already in use.

|||

Thanks for your reply!

Do I need to have separate shared disk for 2005 instances or is this something recommended ?

|||Yes. Each 2005 instance requires separate physically shared disk and IP address.

No comments:

Post a Comment