/// <summary> /// Configure an Availability group for multiple secondary replicas. This performs the following steps /// <list type="number"> /// <item>Backup databases on primary.</item> /// <item>Join each secondary replica to the AG.</item> /// <item>Restore databases on each secondary replica.</item> /// <item>Join databases to AG on each secondary replica.</item> /// </list> /// </summary> /// <param name="agName"></param> /// <param name="primaryReplica"></param> /// <param name="secondaries"></param> /// <param name="databases"></param> /// <param name="fileShare"></param> public static void ConfigureAGforMS(string agName, Smo.Server primaryReplica, IEnumerable <Smo.Server> secondaries, IEnumerable <Database> databases, string fileShare) { foreach (Database db in databases) { AGDBHelper.BackupDatabase(fileShare, primaryReplica, db.Name); } foreach (Smo.Server secondaryReplica in secondaries) { ARHelper.JoinAG(agName, secondaryReplica); foreach (Database db in databases) { AGDBHelper.RestoreDatabase(fileShare, secondaryReplica, db.Name); } foreach (Database db in databases) { AGDBHelper.JoinAG(db.Name, agName, secondaryReplica); } } }
public static void BackUpAndRestoreDatabase(string fileShare, SMO.Server sourceServer, SMO.Server targetServer, string dbName) { AGDBHelper.BackupDatabase(fileShare, sourceServer, dbName); AGDBHelper.RestoreDatabase(fileShare, targetServer, dbName); }