Solved

Cluster WIndows 2008 R2 for SQL 2008R2

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

Accepted Solution

by:
arnold earned 500 total points
Comment Utility
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
Comment Utility
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

Are your corporate email signatures appalling?

Is it scary how unprofessional your email signatures look? Do users create their own terrible designs and give themselves stupid job titles? You can make this a lot easier for yourself by choosing an email signature management solution from Exclaimer today.

Join & Write a Comment

Suggested Solutions

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. Theā€¦

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now