Engine replication is the same for the SQL Server AG virtual database as other SQL Server virtual databases. However, for replication to work for the SQL Server AG virtual database, the user needs to make sure that the SQL Server AG virtual database exists on the source engine.
Best practices for Engine replication with SQL Server AG virtual database
-
Verify that the primary replica of the SQL Server AG on the target cluster and the primary replica currently shown in the runtime attributes for the SQL Server AG virtual database on Delphix Engine match.
-
Make sure that the synchronization state of all the AG VDB replicas is available under the SQL Server AG VDB replica time flows and that it matches the synchronization state currently shown in SQL Server on the target cluster. See Best practices for SQL Server AG VDB operations section in the Provisioning a SQL Server AG virtual database topic for more details.
-
Make sure that either the SQL Server AG virtual database has been disabled on the source engine or in the event the source engine is not available, the underlying database of the SQL Server AG virtual database has been manually cleaned up on the target cluster before an Enable operation is attempted for the AG virtual database on target replication engine.