/// <summary>
/// Configure an Availability group. This performs the following steps
/// <list type="number">
/// <item>Join the secondary replica to the AG.</item>
/// <item>Backup the databases from primary replica and restores it in secondary.</item>
/// <item>Joins the database to primary.</item>
/// </list>
/// </summary>
/// <param name="agName"></param>
/// <param name="primaryReplica"></param>
/// <param name="secondaryReplica"></param>
/// <param name="databases"></param>
/// <param name="fileShare"></param>
public static void ConfigureAG(string agName, Smo.Server primaryReplica, Smo.Server secondaryReplica, IEnumerable <Database> databases, string fileShare)
{
ARHelper.JoinAG(agName, secondaryReplica);
foreach (Database db in databases)
{
AGDBHelper.BackUpAndRestoreDatabase(fileShare, primaryReplica, secondaryReplica, db.Name);
}
foreach (Database db in databases)
{
AGDBHelper.JoinAG(db.Name, agName, secondaryReplica);
}
}
public void AddDatabasesIntoAG(List <string> listDbNames)
{
AvailabilityGroup ag = primary.AvailabilityGroups[agName];
if (ag == null)
{
return;
}
foreach (string dbname in listDbNames)
{
AvailabilityDatabase adb = new AvailabilityDatabase(ag, dbname);
adb.Create();
foreach (Smo.Server srv in secondaries)
{
AGDBHelper.JoinAG(dbname, agName, srv);
Thread.Sleep(1000);
}
// wait a bit to let adb join ag
}
}
