Groups | Blog | Home
all groups > sql server clustering > october 2007 >

sql server clustering : How to create a new instance



jetoo
10/22/2007 12:00:00 AM
Hi all,

I perfectly well understand how to create a SQL 2005 cluster. So I
have a 2 node Cluster Active/Passive, on which i have SQL 2005
installed, with a quorum disk. Everything's fine.

Now, i have several others servers to install (Exchange, Moss, OCS),
each servers need an instance in SQL. I have a san with disks (Each
disks will be attached to each server).

How can I add each disks in the cluster? This has to do with virtual
server in SQL, but i don't know how to do it.
I don't understand well how to do these.

Thanks for the help. :)
Linchi Shea
10/23/2007 9:02:01 AM
First, get your SAN admin to present the disk (LUN) to the server. From
there, you can initialize and format the disk on the server just like any
local disk.

Second, create a new resource group in the cluster and add that disk(s) to
the group (actually create a disk resource for the disk in the group).

Third, get a new IP address and a new network name for the IP address. You
should register the IP and the network in DNS. (Your SQL instance install
will suceed even if you don't register them. But the registration done by the
SQL install is not permanent). But don't add them to the group created above.

With the new resource group having the disk resources in place, you are
ready to install the new SQL instance in the cluster. During the install,
when you are asked to select a resource group for the new SQL instance, pick
the new group.

The SQL install will add several resources to the group including a SQL
Server resource, a SQL SErver Agent resource, a SQL IP resource, a SQL
network name resource, and a SQL Server full text resource.

Linchi

[quoted text, click to view]
AddThis Social Bookmark Button