March 21, 2008 at 12:33 pm
Iam doing clusteing now,So how to know the virtual ip addresses of the two physical machines that we are going to cluster?
thanx
March 21, 2008 at 2:12 pm
you should ask your Windows Admin. they are supposed to provide you this.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 21, 2008 at 4:02 pm
The virtual IP used should be provided by the sys admins. Tell them you need at least one IP for each NIC of the SQL Server, don't forget about the heartbeat NIC. Once your physical boxes are configured, you will need a IP for the SQL server which they should also provide.
Remember, you just set up your cluster and assign resources prior to installing SQL server. Make sure your Quorum drive is sufficient and is not shared with anything else.
In other words, at a minimum, you need 5 ip addresses, I can dig up an old white paper if you want, just let me know if you have any questions
Marvin Dillard
Senior Consultant
Claraview Inc
March 22, 2008 at 9:33 am
Thanx marvin,It would be helpful if you provide me the old white paper and if possible provide any screen shots.
March 22, 2008 at 4:08 pm
Connect the shared storage buses and assign drive letters
Updated: January 21, 2005
To connect the shared storage buses and assign drive letters
1.
Install Windows Server 2003, Enterprise Edition or Windows Server 2003, Datacenter Edition on all nodes.
Caution
•
All nodes in a cluster must be running the same version of the operating system, that is, either Windows Server 2003, Enterprise Edition or Windows Server 2003, Datacenter Edition. You cannot run both Windows Server 2003, Enterprise Edition and Windows Server 2003, Datacenter Edition on nodes in the same cluster.
2.
Prepare the controllers for the shared storage bus, following the instructions in your storage bus owner's manual.
3.
Install the controllers for the shared storage bus, but do not connect them to the shared storage bus.
4.
Connect the shared storage devices to the shared buses, and then connect the shared storage buses to all nodes.
5.
Start the operating system on the first node on which you intend to create the cluster.
6.
Format the disks on the cluster storage device as NTFS.
For more information, see "To format a basic volume" in Related Topics.
Caution
•
Each disk on the cluster storage device must be a basic disk, not a dynamic disk.
7.
Partition the disks on the cluster storage device.
For more information, see "To create a partition or logical drive" in Related Topics.
8.
Do one of the following:
•
Assign drive letters to the disks on the cluster storage device.
•
Assign mount points to the disks on the cluster storage device.
For more information, see "To assign, change, or remove a drive letter" and "To create a mounted drive" in Related Topics.
Caution
•
Make sure that you create unique mounted drives so that they do not conflict with existing local drives on any node in the cluster.
•
Do not create mounted drives between disks on the cluster storage device (cluster disks) and local disks.
•
Do not create a mounted drive from a clustered disk to the cluster disk that contains the quorum resource (the quorum disk). You can, however, create a mounted drive from the quorum disk to a clustered disk.
•
Mounted drives from one cluster disk to another must be in the same cluster resource group, and must be dependent on the root disk.
9.
Label all partitions to match their drive letters or mount points assigned in the step above.
10.
Use Cluster Administrator to add the first node to the cluster.
For more information, see "To add the first node to the cluster" in Related Topics.
Caution
•
Completely create the cluster on one node before you join additional nodes to the cluster.
Important
•
When you create a cluster, Physical Disk resources will be automatically created for cluster disks that use drive letters. However, if your cluster disks use mount points, Physical Disk resources will not be automatically created for those disks; you must manually create disk resources for cluster disks that use mount points. For more information on how to do this, see "Checklist: Installing a Physical Disk resource" in Related Topics.
11.
Join one or more additional nodes to the cluster.
For more information, see "To add additional nodes to the cluster" in Related Topics.
Top of page
Information about functional differences
•
Your server might function differently based on the version and edition of the operating system that is installed, your account permissions, and your menu settings. For more information, see Viewing Help on the Web .
Marvin Dillard
Senior Consultant
Claraview Inc
March 22, 2008 at 4:13 pm
There is also a very good video at the following link. B Knight is one of the founders of this site and is well known in the SQL Server community.
http://www.jumpstarttv.com/Media.aspx?vid=33
Marvin Dillard
Senior Consultant
Claraview Inc
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply