Thursday 11 June 2020

How to set Database Activation Preference number for a Database in Exchange server 2016

I was working in a project, had to migrate the Exchange Sever 2013 environment to Exchange 2016. The environment was consist of PR (4 servers) and DR (3 servers), Total of 30 databases.

At one point i had to play with the DAG failover/switchover, in which i found that every time i activate any of the DBs on any desired server, after some time (1-2 hours) the DBs automatically move/activate back on the first server in the PR site.

After looking into it more i noticed that the "ActivationPreference" value on that server was lowest, set to "1".
So as per the default behavior of the DAG, every time if there is any issue in the DAG/database copies, the DAG will activate the DB on the server which has the most healthy copy. If all the servers have the healthy copies then the copy on the server with the lowest "ActivationPreference" number , i.e "1", will be activated.

So now i have to change the "ActivationPreference" number of all the 30 DBs but you know from the ECP it was a lengthy task so i followed the following steps in the Exchange management shell and performed it very easily and in a very short time.

First i had to check the current status (ActivationPreference value) of each of the DB with the following command.

Get-MailboxDatabase service1603 | fl servers, ActivationPreference


Then i used the following command to set the "ActivationPreference" value as per my requirement.

Set-MailboxDatabaseCopy -identity ‘service1603\MBS03’ -ActivationPreference 1

To check/verify the changes use the following command again but it took some time to show the updated value but in ECP the update value was appearing. 

Get-MailboxDatabase service1603 | fl servers, ActivationPreference
so you should give it some time or check in ECP the updated values. 


No comments:

Post a Comment