- Kofax TotalAgility 7 or above.
- SQL Server 2016 and before
- Is it possible to use SQL Server Always with Kofax TotalAgility databases
Known Causes / Background
The TotalAgility DB consists of 3 parts when processing/completing jobs:
These databases are by default in the same TotalAgility DB, but can be separated depending on customer requirements as assist with DB maintenance and also scalability.
Resolution / Answer
If any of these DBs are separated, it is possible for single transactions to be occur over crossed databases and thus is not supported by SQL AlwaysOn. SQL AlwaysOn doesn’t support cross-database transactions in the same SQL database instance.
In SQL Server 2016 and before, cross-database transactions within the same SQL Server instance are not supported for availability groups. This means that no two databases in a cross-database transaction may be hosted by the same SQL Server instance. This is true even if those databases are part of the same availability group. Cross-database transactions are also not supported for database mirroring.
This is a SQL Server Always On limitation, and as mentioned in the KTA Best Practice guide if the customer wants to use SQL AlwaysOn to have Live, Audit and Archive objects in the same database.
Please find the following information from Microsoft:
Keywords: SQL Always On,AlwaysOn,TotalAgility, Total Agility