SQL Server AG as Target database limitations
Currently, the following product features are not supported for the SQL Server AG as Target database:
Engine UI for managing SQL Server AG virtual database
Snapshot an SQL Server AG virtual database
Start an SQL Server AG virtual database
Stop an SQL Server AG virtual database
Rollback an SQL Server AG virtual database
Undo a refresh for an SQL Server AG virtual database
Upgrade/Downgrade an SQL Server AG virtual database
Migrate to an SQL Server AG target instance, or another AG target cluster
Usage threshold policy for an SQL Server AG virtual database
FORCE disable an SQL Server AG virtual database
Fast Provision or Fast Refresh an SQL Server AG virtual database, meaning provisioning or refreshing the AG virtual database without performing database backup and restore.
Support for CDC, TDE and other VDB config parameters is not available for the SQL Server AG virtual database.
Support for Virtual to Physical (V2P) for an SQL Server AG virtual database is not available.
Hooks except the ConfigureClone hook are not supported for an SQL Server AG virtual database.
Extended properties are not available for the SQL Server AG VDBs as compared to standalone VDBs
Currently, the following configuration(s) are not supported in the context of SQL Server AG as Target:
Nodes of the Windows Server Failover Cluster (WSFC), whose instance(s) are participating in the Always-On Availability group, when added as standalone environments to discover Target AG cluster(s), are not to be used for provisioning a standalone virtual database. Likewise, they are not to be used as a staging environment for dSource(s). Additionally, these are not to be used as proxies to add any environment.
Users cannot create dSource(s) with AG configuration on a target cluster.
Users will not be able to create the virtual database (s) on AG configurations where FC instances are added as replicas of the SQL Server AG.
Windows failover cluster with an Availability Group can only be added as either a Source or Target environment. It cannot be used as both a Source and Target at the same time.
Enable operation with the isAttemptStart parameter set to false is not supported for an SQL Server AG virtual database.