create the Resource Group in Windows Server 2008

Question

Post reply

create the Resource Group in Windows Server 2008

pshaship

SSCertifiable

Points: 6125
More actions
August 19, 2010 at 10:20 am

#239175

Hi,
We have created a single Cluster node on Windows server 2008 x64. Now we need to create the Resource Group and assign the Physical disks to that resource group and install SQL Sevrer 2008.
How to create a resource group in Windows 2008? I did not find that option. please advice
Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Derrick Smith SSChampion Points: 10833 More actions · Answer 1

Open the Failover Cluster Manager

Right click Services and Applications -> More Actions -> Create Empty Service or Application

Name it whatever you want, add your disks, then install SQL to it.

pshaship SSCertifiable Points: 6125 More actions · Answer 2

Thank you,

We just build a new single cluster node with Windows 2008.

I have created a resource group called SQL Group. Now there are many option when we right click that group. I just add the Disks to that group. On Windows 2003, after adding the physical disks to the SQL resource, I directly used to install SQL Server, which automatically used to add IP address & Netwrok name. Is this same still in Windows 2008? or do I need to add IP address & Network name to the SQL Group before installing SQL Server 2008?

Could you please advice me what are the required components to add to the above created group, SQL Group

I did find the documnetation SQLServer2008FailoverCluster.docx for How to install SQL Sevrer 2008 on Windows 2008 cluster .

But I did NOT find the documentation for what needs to be done prior to the SQL install . i.e steps after building cluster and before installing SQL Server 2008 like

1. How to create a Cluster group?

2. Required components to add for resource group created at step1?

3. Do we need to create and configure msdtc & Quorum before installing SQL Server?

Please provide me links for the documnets exaplaining the above

Thank you very much

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

you should already have some sort of quorum in force even on the single node cluster.

Create a clustered DTC application and then install SQL Server failover cluster.

The necessary groups, IP and name resources, etc will be added automatically. You might want to check the resources dependencies afterwards.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Derrick Smith SSChampion Points: 10833 More actions · Answer 4

Setting up the cluster in 2008 is almost identical to 2003, except that a few names are changed and moved around.

You still create an empty group, add disks to that group, and then install SQL. It will automatically add the IP, name, etc you specify during the install. You will have to manually add the disks as dependencies to SQL after it's done, just like 2003 also.

The quorum should already be set up..although it sounds like you have a single node cluster (planning to add a second later?), which I haven't had any experience with.