Solved

Cluster WIndows 2008 R2 for SQL 2008R2

Posted on 2010-09-07
2
689 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
2 Comments
 
LVL 77

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
windows 10 versions 3 34
MS Endpoint Protection 2 24
SQL Replication question 9 41
Set up secondary Domain Controller 4 70
A procedure for exporting installed hotfix details of remote computers using powershell
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

776 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