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.
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(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' %3EV%3C/text%3E%3C/svg%3E)
Vishu
1,576
Reputation points
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
SQL Server | Other
Answer accepted by question author
-
Olaf Helper 47,586 Reputation points2021-09-17T11:41:36.71+00:00
2 additional answers
Sort by: Most helpful
-
![](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)
Seeya Xi-MSFT 16,676 Reputation points2021-09-20T06:29:07.053+00:00 Hi @Vishu ,
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.htmlBest 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. -
Vishu 1,576 Reputation points
2021-09-20T06:46:26.673+00:00 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.
-
Seeya Xi-MSFT 16,676 Reputation points
2021-09-22T06:51:17.907+00:00 Hi @Vishu
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.
Sign in to comment -