Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Cluster WIndows 2008 R2 for SQL 2008R2

Posted on 2010-09-07
2
Medium Priority
?
704 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 80

Accepted Solution

by:
arnold earned 2000 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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
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…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

610 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