I am getting DAG errors but it may be related to the Cluster being offline? I am getting Error Code: 0x80071736 The resource failed to come online due to the failure of one or more provider resources.
set-databaseavailabilitygroup DAGname gives Dagname is not online.
set-databaseavailabilitygroup DAGname -WitnessServer computer3.test.com -WitnessDirectory c:\witnessshare -DatacenterActivationMode DagOnly gives error:: network name Dagname is not online. Please check that the IP address configuration for the database availability group is correct
Dagname is changed for this example.
any suggestions would be great
I do see the info in Microsoft Failover Cluster manager and can right click on it but when I click bring online it errors out.
2 answers
Sort by: Most helpful
-
-
Xiaowei He 9,891 Reputation points
2020-10-14T07:26:07.73+00:00 Hi,
Please check that the IP address configuration for the database availability group is correct
Firstly, please use the following command to check if the DAG network settings are misconfigured:
Get-DatabaseAvailabilityGroupNetwork | fl >c:\DAGnetwork.txt
If the DAG network is correct, please check if the IP address resource can be online in the Cluster manager? Please provide the screenshot of the resource that can't be online in the cluster, and provide the error message when try to bring the failed resource online.
Thanks for your time!
Best Regards,
Anne-----------------------------
If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.