I'm installing a fresh SQL2000 build on a new cluster. Using NT4 Enterprise. I have a 2 disc mirror and 3 disk raid5 array. When the SQL install...

How It Works

Get an answer in three easy steps. Here's how it works...

Ask Your Question

1. Ask Your Question

Enter your programming question at the top of this page and click Get An Answer.

Pick Your Priority

2. Pick Your Priority

Tell us how quickly you want your programming question answered.

Get An Answer

3. Get An Answer

Connect with your programmer via online chat or telephone call.

Answer

Customer
I'm installing a fresh SQL2000 build on a new cluster. Using NT4 Enterprise. I have a 2 disc mirror and 3 disk raid5 array. When the SQL install starts it asks me to select the cluster disk where DATA files will be placed. I select the 3 disc raid5 array. I then get a warning message stating I have chosen a group containing the "quorum" resource, which it dosn't recommend. What does this mean, I thought the Quorum was the Transaction Log..I'm aiming for the transaction logs to go on the 2 disc mirrored set and the database to be on the Raid5 array. Any help very welcome as no books we have mention this.. Thanks in advance. John
Posted
cckane1973
Programmer
When installing SQL2000 in a Clustered environment, there is a recommended QUORUM DRIVE, usually recommended to be 500 megs, for the ability for TRANSACTION information for the CLUSTER to be stored, this allows the cluster to write information to the cluster so that the other CLUSTER MEMEBER is aware of changes made and allows for a single node to Command control of the cluster, without the QUORUM drive, the cluster fails. QUORUM drives ARE REQUIRED. Best way to do it is create to logical disks, one with a 50-500 meg Quorum drive, and the rest for the shared array for SQL. Any questions, review this support article: http://support.microsoft.com/support/kb/articles/Q280/3/45.ASP
Posted

quoteTestimonialsquote

About ExpertHelp

ExpertHelp is changing the way you connect with service professionals.

Whether you have a quick question while preparing your taxes, troubleshooting a computer problem, or need to hire an attorney, ExpertHelp is the most convenient and affordable way to connect with the right service professional to get the job done.

ExpertHelp has been in business since 2011, is an A+ Rated Better Business Bureau accredited member, and offers a 100% satisfaction guarantee on every question you ask!

More Programming Questions...

Ask Your Programming Question & Get An Answer Now!