This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 60%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVG%3C/text%3E%3C/svg%3E)
Hi Experts,
Would you be aware of some application/database restrictions on a general basis wherein they would not be compatible with AlwaysOn AG , maybe some suggestions by MS
If can please guide
Additional SQL Server features and topics not covered by specific categories
Answer accepted by question author
The AlwaysOn AG feature is transparent for the clients, they are not aware of.
But if you have doubt's, then ask the software vendor, he should know it best.
Thanks , i got the response.
However one last query. Are databases having transactional replication with replication happening for selected tables good candidates for an AlwaysOn Setup.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @Vishal Garg
Please see:
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-replication-for-always-on-availability-groups-sql-server?view=sql-server-ver15
A static row filter uses a WHERE clause to select the appropriate data to be published. When setting up the publication, we can add a filter to only publish specific records.
Best regards,
Seeya
If the response is helpful, please click "Accept Answer" and upvote it.
Hi @Vishal Garg ,
I agree with Olaf. > But if you have doubt's, then ask the software vendor, he should know it best.
Take Autodesk Vault as an example:
https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/Autodesk-Vault-and-SQL-Failover-Clustering.html
Best regards,
Seeya
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.