Solved

Cluster WIndows 2008 R2 for SQL 2008R2

Posted on 2010-09-07
2
691 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

This article explains how to install and use the NTBackup utility that comes with Windows Server.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
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.

738 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