SQL Transaction Logs file size increase unexpectedly and becomes full when FULL Recovery Mode is enabled (292171)

This is expected behavior in SQL if FULL Recovery Mode is selected.

Refer to Microsoft's Knowledge Article and another online source that explains this:

https://support.microsoft.com/en-us/help/317375/a-transaction-log-grows-unexpectedly-or-becomes-full-in-sql-server

https://www.mssqltips.com/sqlservertip/5343/understanding-sql-server-recovery-models-and-transaction-log-use/

This is not an Active Roles or Quick Connect Sync Engine issue but an expected behavior in SQL when FULL Recovery Mode is selected.

RESOLUTION:

Work with a DBA or Backup Admin to work on a plan to back up Transaction logs regularly.

Microsoft's recommendation on back up plan for transaction logs  :

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/transaction-log-backups-sql-server?view=sql-server-2017

Microsoft's recommendations on how to back up transaction logs:

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-a-transaction-log-sql-server?view=sql-server-2017