Solved

Cluster WIndows 2008 R2 for SQL 2008R2

Posted on 2010-09-07
2
692 Views
Last Modified: 2012-05-10
I have started to prepare a Windows 2008R2 cluster for use with SQL 2008 R2 clustering. I have 5 shared LUNS. I created the cluster and added all the LUNS to storage. I then installed MSDTC on one of the LUN and moved the quorum disk to another LUN. One thing I have noticed now is that 2 of my LUNS are in the available storage group while one of the LUNS is in a goup called 'Cluster Group'. I want to be able to use the  3 remaining LUNS for the SQL install. 2 are for the user databases (logs and db's) and the other one is for the system databases. I am new to shared clustering. Why is this LUN in the cluster group and why aren't the others there?
0
Comment
Question by:mvozila
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 78

Accepted Solution

by:
arnold earned 500 total points
ID: 33623780
I think the wizard grabs the minimum required resources. During the custom confguration when you point the storage of the system databases to the second LUN it will likely be added to the group.

Not sure why you would want to separate the system databases from the user databases in terms of the LUN.
You may want to use one LUN for the daabases and the other for the Transaction logs and the third possibly for the backups.
0
 
LVL 1

Author Comment

by:mvozila
ID: 33630747
The SQL install wizard didn't seem to think this was available. This LUN was orginally used as the Quorum disk and then moved it to a different LUN. I ended up removing the volumes and setup the cluster again. When I moved the Quorum this time I took it offline and then moved it. When that completed I had all my available LUNS back. Strange. Needless to the say the actual SQL 2008 R2 clustering piece was a piece of cake. I had just struggled with some quirky issue in setting up the Windows cluster. All is happy now. Thanks.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question