Quorum Disk - Clustering SQL 2005
Feb 18, 2008
Dear All,
I am trying to setup clustering for SQL 2005. I initially want to setup a 2 node cluster in Active/Active Configuration.
I am trying to understand the Quorum disk in SQL 2005. As I understand the quorum disk is a shared resource. How is this resource configured? Would I need to have an iSCSI or fibrechannel connection from each of the nodes to the shared disk?
As well, does each node have a separate data drive? Or do all the nodes use only the shared storage?
Thank you.
View 1 Replies
ADVERTISEMENT
Jun 20, 2015
I have a windows 2012 cluster environment that consists of two SQL servers nodes with Quorum disk configured as witness.
Manual failover between nodes is working fine, however the sql instance virtual is not seeing the Quorum disk.
Moreover the Quorum disk has the same number as another cluster storage disk, is that considered a problem?
When I move the SQL instance from a node to anohter, should the Quorum Disk change ownership as well to that destination node ? if it is not changing ownership what would be the problem??
View 3 Replies
View Related
Nov 15, 2006
Hello,
I am trying to setup a test cluster and am having an issue. When I try to create the resource of a physical disk it takes both the drive e: and drive q: and doesn't seperate them into two physical disks as resources. This means when I try to associate the quorum disk it links the to physcial disk resource of drive e and q. Then when I try to install SQL2k5 I get the warning about installing SQL on the quorum disk. Am I missing something? Is there a way to seperate e and q onto two physical disk resources so I can specifically associate the quorum to q and the sql to e or should I be setting the quorum disk to a majority node set? Thanks in advance.
John
View 4 Replies
View Related
Jan 18, 2007
Hi,
I'm trying to install a server cluster to implement an SQL Server 2005 cluster. No other services (I think this is important).
I've a dual SCSI channel Smart Array with 4 disks configured in a 400Gb RAID 5.
I do not need to move different resource groups from one node to the other, I need only one group with all the resources IP, Network name, MSDTC, and SQL Server..., when a node fails, all services should failover to the other node.
Is it possible to have only one physical disk (RAID 5) for Quorum disk and shared disk?
It would be the following configuration:
[Groups]
Cluster Group
IP Address
Network Name
Physical disk (used for quorum and shared storage)
Distributed Transaction Coordinator
SQL Server
SQL Server Agent
Generic Service (SQL Server Fulltext)
The other option would be having a 1 physical disk Raid 0 for Quorum (146Gb wasted) and another physical disk Raid 5 (3 disk) for Shared Storage, but this schema will have a a flaw point that if Quorum disk fails, the cluster fails....
Any help would be appreciate.
Best regards.
Ilde.
View 1 Replies
View Related
Feb 15, 2006
Dear All,
I've the quorum disk of my cluster on win2003 full and I cannot use The cluster administrator because the Service Cluster cannot going up.
Obviously the shared disk (included Quorum) and MSDTC are not visible and I'm wondering if is possible to solve the problem without rebuild the cluster.
Thank you to everybody
View 1 Replies
View Related
May 25, 2015
Quick question re a 2008 failover cluster with Node and Disk Majority:
Under healthy conditions does it matter which node owns the Quorum disk?
My understanding was that the quorum disk should be owned by the active node, in the same way that it owns the active data/log disks?
I've just finished off setting up a cluster and noticed that the quorum seems to want to be held by the passive node.
I've attempted to move it to the active node but nothing seems to happen.
View 0 Replies
View Related
Dec 28, 2006
hello,all
I am new to Sql 2000,I installed sql 2000 database in C disk,but Now I found my C disk space is smaller than before,So I want to move my databse(include data and structure) from C Disk to D Disk(its space is very large) .
is it possible to do it ?
if its can be done ,do I need to change my asp.net program source code (exp: chaneg my crystal report connectstring ) ?
thanks in advanced!
View 1 Replies
View Related
Oct 22, 2007
hi all....active/active. windows 2003 sp2. two nodes. two instances, each on a separate virtual server. my msdtc resource is in the cluster group. when i have the cluster group on one node, the sql instance that is running on the other node can't see DTC. Makes sense since the service is not up, but is this a problem? Seems strange to have a red stop sign on my dtc icon in sql management studio. I suppose I won't be able to run Distributed Transactions on that node, which kinda stinks. Wondering if anyone has seen a workaround.
View 3 Replies
View Related
Aug 24, 2006
Hi,
Would anyone give me some directions on where I could get good information on Windows 2003 and SQL 2005 clustering??
Thanks in advance.
View 3 Replies
View Related
Mar 27, 2008
Hello,
I am using MS Virtual Server and wanted to configure sql 2005 clustering.
My configurations are:
1. DC
2. Node1
3. Node2
DC, Node1, and Node2 are in the domain.
1. Bring up the DC
2. Bring up the Node1
3. Bring up the Cluster Administrator and started the clustering configuration.
4. I run into serveral errors.
Services won't start:
Error 1067: The process terminated unexpectedly.
Could not start the Cluster Service service on local computer.
Errors on Clustering Config:
The cluster node is down
The node is already a member of a cluster but the cluster services is not running. This node will not be configured at this time
Can someone help and advise.
Thank you.
Edwin
View 1 Replies
View Related
Sep 28, 2005
In reading material on the quorum drive on a sql server cluster in mentions this is the drive the logs are written to. Is this referring to sql log files that are dumped by a process or scheduled job, or some other log files?
View 1 Replies
View Related
Aug 6, 2007
Hi,
Please tell me that,
What is Clustering in SQL SERVER 2005 Database?
What is the main reason of Clustering in SQL SERVER 2005 Database?
What are the advantages of Clustering in SQL SERVER 2005 Database?
How can I implement Clustering in SQL SERVER 2005 Database?
waiting for your reply with thanks
T C
View 2 Replies
View Related
Jun 9, 2008
Friends -
I am going to install sql server 2005 clustering on windows 2003 o/s.
i am using active/passive clustering.
On node : 1 i created a shared disk, quorum, volume1, volume 2 under disk management.
my doubt is do i need to do the same thing again on node :2 like (create shared disk, quorum, volume1, volume 2 same as node:1
Please advise on this.
Cheers:)
vsh
View 7 Replies
View Related
Jul 11, 2006
Hi,
Pl clarify how to use SQL server 2005 clustering Algorythm , I want to use the case and nested table concept. Pl let me know what is key column , Input and product with an example
I have table in the following structure
Cust_id
Age
Product
Location
Income
the above mentioned columns are in my tableand i want to perdict which product is mostly likely to sold with other based on age , location and income
Pl clarify and mail me on rajesh.ladda@lntinfotech.com
Thanks in advance
Rajesh Ladda
View 1 Replies
View Related
Jan 18, 2007
I am getting ready to have a SQL Server failover cluster setup. I have used SQL 2000 for years, mostly for DTS and related database activities, but NOT in a cluster. I have used SQL 2005 for about one year but not intensively, and NOT in a cluster.
We need to set up a cluster. We are setting up a DELL EMC solution. I am going to hire a consultant to set it up, including the SQL part. My questions are should I use SQL 2000 or 2005? (I don't know if one is better than the other for clustering. Both are supported by our vendor for the application we are running.) How hard is it to maintain a cluster if one hasn't had experience in that area before? How should I prepare?
Any opinions or experiences that you would like to share would be helpful.
Thank you.
View 1 Replies
View Related
Sep 12, 2006
Hi all,
I am new in clustering setup and I have a MSSQL2005 (Enterprise edition SP1 and Win2003 Enterprise edition) standalone production server and it will be setup with clustering and SAN. How can I setup the clustering? What are the steps?
I have a testing machine to setup new sql clustering which is working fine. I wonder how to setup from a standalone server. Kindly advise. Thanks in advance
View 1 Replies
View Related
Oct 19, 2006
Installing a SQL2005 active/passive cluster for the first time and have an issue/question. When running throught the SQL2005 setup and you have to enter the Virtual Server name, I enter the Virtual name that has been allocated an IP address and up pops a message saying the name already exists. Why is this? Surely the name and IP address have to be in place before running the setup. Slightly confused here.
Any help would be much appreciated.
Thanks
View 1 Replies
View Related
Jul 8, 2005
My company is planning on using a datacenter for our customers. These are manufacturing plants from which we collect batch and trend data (currently stored in SQL Server)
View 6 Replies
View Related
Jan 10, 2007
Hi,
We have SQL 2005 2 node active-active clustering with 2 instances on each node.(total 4 instances).
Is it possible to apply Service packs to just 1 instance or does it impact all 4 instances on both nodes ?
View 9 Replies
View Related
Sep 28, 2007
I am developing an enterprise class solution using SQL Server 2005 and MS .NET v2 and am tying determine if SQL Server 2005 (which edition and if so how) would be adequate for my proposed solution. Any feedback, tips, comments would be greatly appreciated.
As a background the solution I am developing will be web services based and used by multiple offices around the globe by over 500 users. I have already developed a prototype using a single SQL Server 2005 instance but as this solution is going to be used by offices around the world I want to have an IIS Server and SQL Server 2005 server instance in each office with "links" back to the primary SQL Server 2005 cluster in Australia.
One of my thoughts was to set up replication between the offices that would happen at midnight remote office local time and then set up triggers to update the primary cluster when assoociated data was changed on the remote sites or on the primary cluster. Does anyone know or can anyone suggest alternatives to this strategy?
I effectively need some sort of inter site caching functionality with store and foreward capabilities ...
Thanks
Andrew
View 6 Replies
View Related
Sep 10, 2007
If I return the Average, Minimum, and Maximum values for the counter Physical Disk: Avg. Disk Queue Length, and those values are 10, 0, 87 respectively, which value do I use to compute the Avg. Disk Queue Length for a 4 disk array(RAID 10): Average, Minimum, or Maximum? The disk(lun) is on a SAN.
View 1 Replies
View Related
Oct 13, 2006
We are trying to setup a Windows Server 2003 Cluster with 2 systems and a DAV. We intend to install SQL 2005 on this Cluster. We purchased a DAV with 3 physical disk arrays as follows.
73GB RAID 1 (our plan is to use this to store sql transaction logs)
146GB RAID 1 (sql backups, temp database & other temp files)
420GB RAID 10 (sql databases)
Now as we are setting all this up we find out we need a shared physical drive on the DAV to store the Quorom. It is my understanding we cannot partition the physical drives and use one of the partitions to store the Quorum because when you create the resource for the Quorum the resource is the phsyical disk not the partition.
So my question is, is it in our best interest to buy a seperate physical disk for the Quorom?
My next question is, with regards to the MSDTC, is it in our best interest to buy a seperate physical disk for the MSDTC or can we store it on the 146GB RAID 1 and still use the drive for its original purpose?
Any guidance is much appreciated.
- Nick
View 13 Replies
View Related
Apr 4, 2008
Hi,
I am trying to set up a SQL 2005 analysis server cluster in our two servers, AS02 and AS04. The server cluster is built up on Majority Node Set (MNS). During the installation of the analysis service, I don't see the available cluster groups. In the cluster admin, the cluster is up and running fine. The MNS cluster has no shared disk, and it has two nodes.
Any thoughts or suggestions? or is it possible to built the SQL 2005 analysis service cluster with MNS?
Thanks.
View 4 Replies
View Related
Nov 13, 2007
-- Initialize Control Mechanism
DECLARE@Drive TINYINT,
@SQL VARCHAR(100)
SET@Drive = 97
-- Setup Staging Area
DECLARE@Drives TABLE
(
Drive CHAR(1),
Info VARCHAR(80)
)
WHILE @Drive <= 122
BEGIN
SET@SQL = 'EXEC XP_CMDSHELL ''fsutil volume diskfree ' + CHAR(@Drive) + ':'''
INSERT@Drives
(
Info
)
EXEC(@SQL)
UPDATE@Drives
SETDrive = CHAR(@Drive)
WHEREDrive IS NULL
SET@Drive = @Drive + 1
END
-- Show the expected output
SELECTDrive,
SUM(CASE WHEN Info LIKE 'Total # of bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS TotalBytes,
SUM(CASE WHEN Info LIKE 'Total # of free bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS FreeBytes,
SUM(CASE WHEN Info LIKE 'Total # of avail free bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS AvailFreeBytes
FROM(
SELECTDrive,
Info
FROM@Drives
WHEREInfo LIKE 'Total # of %'
) AS d
GROUP BYDrive
ORDER BYDrive
E 12°55'05.25"
N 56°04'39.16"
View 16 Replies
View Related
Mar 31, 2006
Hi
I have a tech question. I have three physical disk drives without a RAID controller and I would like to use those three physical drives as one unit - so that I will be able to use the maximum of the disk capacity on all disks.
How and where I should configure my PC on widnows server 2003 disk drives/units to work as one unit (e.g. C:).
Thanks in advance.
Dean
View 1 Replies
View Related
Nov 13, 2007
We have 2 env. : Testing and Production, both are running Windows 2003 Enterprise Server with SQL Server 2005. The difference is Testing is NOT running Windows cluster but Production do so, what is the best way to transfer a database from testing to production?
We have another systems that both testing and production are running on NON-cluster and we use backup/restore to transfer the database, can it apply in this case.
And I found that there are a tools called DTC, which can transfer all DB objects from one DB to another, is it a best way to transfer between non-cluster and cluster env.?
View 2 Replies
View Related
Nov 2, 2006
We want to use sql 2005 failover clustering feature, so that upgrade sql 2000 is necessary. But some of the stored procedures built in 2000 are not working directly in 2005, set the compatibility level to 80 could make them work. In this case, can somebody here tell me if down grade the database level will affect failover clustering running properly? e.g. will data still be synchronized properly? Thanks in advance.
View 3 Replies
View Related
Jul 16, 2014
I have a cluster using Always on on 2012 and i have set up a Witness file share which losts connectivity the other day and a failover was invoked.
Is there a threshold i can change so that the cluster can try a couple of more times to connect before it fails over ?
View 3 Replies
View Related
Feb 20, 2001
Hello,
this is my configuration :
1) 3 disks in RAID5 that hold the SQL data
2) 1 disk in RAID0 that holds the only paging file.
What will happen to the SQL data (DB) when the disk that holds the paging file crashes?
Kindest regards,
Luc.
View 1 Replies
View Related
Feb 8, 2007
Hi,
I have a question about using MSSQL server 2005 standard edition in Clustering mode.
I would like to build a msql cluster with only 2 servers (2 nodes).
I read here -> http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
page 5 that you can use MSSQL server 2005 standard edition in Clustering mode with 2 nodes.
But my question is :
Can I use windows 2003 standard edition (Clustering mode managed ????) or I only can use windows 2003 enterprise edition ?
J.
View 1 Replies
View Related
Jul 20, 2007
Hi All,
We have here a WinForms Application on laptops that uses SQL Express as its database. Initially all was going well, then it was decided that the laptop Hard Drive should be encrypted. Thats when the fun started.
It is now very hit and miss as to whether we can connect to SQL and service pack 2 will not install.
So now to the question :-
Does anyone know if there are any compatablity issues with SQL 2005 Express and hard disk encryption (particularly BeCrypt).
Thanks
Steve
View 1 Replies
View Related
Aug 4, 2007
As a normal sql user we are not able to get the disk space information by
executing 'xp_fixeddrive' extended stored procedure.
We are able to get the result using sa user and windows authenticated user.
Any help will be appreciated.
View 3 Replies
View Related
Sep 9, 2015
I'm just starting to work with AlwaysOn Availability and WSFC.
I have in my environment (in Azure) a DC, WSFC and to SQL instances, so I have 3 nodes in my Failover Cluster:
WSFC
SQL1
SQL2
If I simulate failure by shutting down one of the SQL boxes my Availability group seamlessly fails over to the other SQL instance - which is great.
However, I'm starting to look into the workings of the Quorum, my envt has the default settings and when I shutdown both of my SQL servers I expected the Cluster itself to go offline as 2 out of the 3 votes will be negative, but the Cluster is still up - Screenshot below when SQL1 and SQL2 are shutdown:
Going through the Wizard (but not changing anything) it shows following config:
View 6 Replies
View Related
