Database switch over automatically

Team,

We are observing dtabase is getting switch over on passive server automatically. Please help me troubleshooting steps to get the RCA. Why it is happening so ?????

February 9th, 2015 4:31pm

Hi,

please check event viewer on all servers to see what causes the database switch over.

We had same issue and found out reason was because we had issue with our Hyper-V cluster.

If main Exchange server is getting switched over to another cluster,this issue will happen.

This is stated in White paper for Virtual Exchange:

When performing live migration of DAG members, follow these key points:

 If the server offline time exceeds five seconds, the DAG node will be evicted from the cluster. Ensure that the hypervisor and host-based clustering use the Live Migration technology in Hyper-V to help migrate resources with no perceived downtime.

 If you are raising the heartbeat timeout threshold, perform testing to ensure that migration succeeds within the configured timeout period.

 On the Live Migration network, enable jumbo frames on the network interface for each host. In addition, verify that the switch handling network traffic is configured to support jumbo frames.

Free Windows Admin Tool Kit Click here and download it now
February 9th, 2015 5:03pm

What all are the events id that generate during  failover.
February 9th, 2015 5:18pm

Hi ,

1.Please check the database copy on the server on which you wants to mount the database is having the least preference number and also it should have to be in a healthy state including the content index files.

2.What about the remaining databases mounted on the server ?Does that databases also failover to the other node  ?

3.What about the result for the below mentioned command on the server on where you want the database to be mounted permanantely?

test-replicationhealth

4.Make sure the network cards on the dag members are configured correctly and it should not to be in a misconfigured state ?

5.If you want to review the event logs then you have to see it on the below mentioned path to find out the reason for the database failover.

Application and service logs ------>microsoft----->exchange---->high availability ------->operational

6.Another method is to find the database failover reason by using the below mentioned script.

CollectOverMetrics.ps1

7.In case if all the above is good and you cannot able to find out the reason for this issue .Then the final option would be to allow the database to get failover to the passive node and then reseed a fresh copy on the node on which you want to mount the database.

Note : Before reseeding you need to delete the problematic copy which includes the .edb files and the logs files and then have the fresh copy.

All the above is done then try to mount that new copy as an active database copy.


Free Windows Admin Tool Kit Click here and download it now
February 9th, 2015 6:59pm

Hi ,

Just search for the event id 306 on the below mentioned path.

Application and service logs ------>Microsoft--->exchange---->high availability ------->operational

February 9th, 2015 7:03pm

https://technet.microsoft.com/en-us/library/dd351258.aspx
Free Windows Admin Tool Kit Click here and download it now
February 10th, 2015 5:17pm

Hi,

Suggestions from S.Nithyanandham are helpful. Please check these suggestions to see if there is any related message about that DAG failover automatically.

And you can also check the application log to see if there is any events about the issue.

The article you provided above can help to monitor DAG.

Best regards,

If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

February 11th, 2015 7:24am

Yes i agree with S.Nithyanandham
  • Marked as answer by Raritan Wednesday, February 11, 2015 10:15 AM
Free Windows Admin Tool Kit Click here and download it now
February 11th, 2015 1:15pm

I m getting error mesaage while runing the collectiveovermetrics script
February 13th, 2015 9:13am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics