May 6, 2015 at 6:13 am
Hi
I want to setup HA
In first step, Befor create cluster , I validate the clustring and get some warning.
As regards, I want to use Listener and Enable AutoFailour (to change automatic primary server) , Need to Investigate All errors careFully
Befor That This is my disks: (Both servers are Virtual machines)
Server A :
- Disk 1 - Drive C
- Disk 1 - Drive D
- Disk 2 - Drive E (This is not Boot Drive)
Server B :
- Disk 1 - Drive C
- Disk 1 - Drive D
- Disk 2 - Drive E (This is not Boot Drive)
First Important warning :
<<<List Disks To Be Validated>>>
>>>>>>>>>>>> No disks were found on which to perform cluster validation tests. To correct this, review the following possible causes: <<<<<<<<<<<<<<
* The disks are already clustered and currently Online in the cluster. When testing a working cluster, ensure that the disks that you want to test are Offline in the cluster.
-- I think this is not reason For this warning.
* The disks are unsuitable for clustering. Boot volumes, system volumes, disks used for paging or dump files, etc., are examples of disks unsuitable for clustering.
-- I think this is not reason For this warning.
* Review the "List Disks" test. Ensure that the disks you want to test are unmasked, that is, your masking or zoning does not prevent access to the disks. If the disks seem to be unmasked or zoned correctly but could not be tested, try restarting the servers before running the validation tests again.
* The cluster does not use shared storage. A cluster must use a hardware solution based either on shared storage or on replication between nodes. If your solution is based on replication between nodes, you do not need to rerun Storage tests. Instead, work with the provider of your replication solution to ensure that replicated copies of the cluster configuration database can be maintained across the nodes.
* The disks are Online in the cluster and are in maintenance mode.
No disks were found on which to perform cluster validation tests.
----------------------------------------------------------------
----------------------------------------------------------------
For more information This Disk List report :
Server A : Disk 1
Model : VMware Virtual disk SCSI Disk Device
Bus Type :SAS
Adapter : LSI Adapter, SAS 3000 series, 8-port with 1068
Disk Characteristics : Disk is a boot volume. Disk is a system volume. Disk is used for paging files. Disk is used for memory dump files. Disk is on the system bus. Disk partition style is MBR. Disk type is BASIC.
Server A : Disk 2 (This disk seems to be for Cluster)
Model : VMware Virtual disk SCSI Disk Device
Bus Type :SAS
Adapter : LSI Adapter, SAS 3000 series, 8-port with 1068
Disk Characteristics : Disk is on the system bus. Disk partition style is MBR. Disk type is DYNAMIC.
-------------------------------
For more information This Disk List report :
Server B : Disk 1
Model : VMware Virtual disk SCSI Disk Device
Bus Type :SAS
Adapter : LSI Adapter, SAS 3000 series, 8-port with 1068
Disk Characteristics : Disk is a boot volume. Disk is a system volume. Disk is used for paging files. Disk is used for memory dump files. Disk is on the system bus. Disk partition style is MBR. Disk type is BASIC.
Server B : Disk 2 (This disk seems to be for Cluster)
Model : VMware Virtual disk SCSI Disk Device
Bus Type :SAS
Adapter : LSI Adapter, SAS 3000 series, 8-port with 1068
Disk Characteristics : Disk is on the system bus. Disk partition style is MBR. Disk type is DYNAMIC.
------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------
I changed Disk 2 type to GPT Disk , But nothing chenged. and message changed to this :
>>>>>>>>>>>>>>>Disk is on the system bus. Disk partition style is GPT. Disk type is BASIC.
May 8, 2015 at 4:27 am
I don't think the disks should be a part of the cluster in the first place.
Always ON HADR solution does not use Shared storage like the traditional SQL failover clustering. But, still it requires the windows clustering feature installed for the purpose of failing over databases in the availability group.
Each node in the cluster should have its own dedicated storage. The Always ON piece ensures that data remains consistent across all the nodes in synchronous mode.
May 8, 2015 at 9:06 am
MotivateMan1394 (5/6/2015)
HiI want to setup HA
Read through my stairway to alwayson on this site starting at this link
http://www.sqlservercentral.com/articles/FCI/107536/[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 9, 2015 at 6:08 am
Hi
Thank You Perry Whittle, Your Text identify and seperate some thing in my mind about clustring.
and Thank you indianscorpion29.
After that I started Clustering And I passed from the share disk warning.
But , I need Automatic Failover. >>> Then I need "Cluster Quorum Configuration - file share witness. "
First of all, is it true ?
---------------------------------
If It is true :
we will configure a file share witness for our cluster quorum configuration.
To configure the cluster quorum configuration to use a file share,
1- right-click on the cluster name, select More Actions and click Configure Cluster Quorum Settings… We will be configuring a file share witness for our cluster quorum setting.
2- In the Select Quorum Configuration page, select the Add or change the quorum witness option. Click Next.
3- In the Select Quorum Witness page, select the Configure a file share witness (recommended for special configuration) option. Click Next.
4- In the Configure File Share Witness page, type path of the file share that you want to use in the File Share Path: text box. Click Next.
<<< In this step I insert a shared path that I created in on another server>>>
5- In the Confirmation page, click Next. In the Summary page, click Finish.
...
But After That I get error :
Errors
An error was encountered while modifying the quorum settings.
Your cluster quorum settings have not been changed.
There was an error configuring the file share witness '\\DK-SQLSRV03\ClusterSharedFolder'.
Unable to save property changes for 'File Share Witness'.
The system cannot find the file specified
Please Help me.
May 11, 2015 at 4:52 am
MotivateMan1394 (5/9/2015)
But , I need Automatic Failover. >>> Then I need "Cluster Quorum Configuration - file share witness. "First of all, is it true ?
How many nodes are in the windows server failover cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 12, 2015 at 3:58 am
2 nods.
And I found the reason of error. It was Permission.
Yes The New Virtual cluster Should has access to the shareFolder.
On sequrity that folder I Grant Full Access to Cluster...$ .
Thank you
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply