Skip to main content
Skip table of contents

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. 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.