/// <summary>
/// Sets database in required state.
/// </summary>
/// <param name="agName"></param>
/// <param name="dbName"></param>
/// <param name="suspend"></param>
/// <param name="server"></param>
private static void SetDbState(string agName, string dbName, bool suspend, SMO.Server server)
{
AvailabilityGroup ag = server.AvailabilityGroups[agName];
AvailabilityDatabase db = ag.AvailabilityDatabases[dbName];
db.Refresh(); // database state is server side property, so the SMO object needs to be refreshed to get the correct value.
if (suspend)
{
db.SuspendDataMovement();
}
else
{
db.ResumeDataMovement();
}
}
