WEM SQL Database is growing to over 20 GB

Citrix is not responsible for and does not endorse or accept any responsibility for the contents or your use of these third party Web sites. Citrix is providing these links to you only as a convenience, and the inclusion of any link does not imply endorsement by Citrix of the linked Web site. It is your responsibility to take precautions to ensure that whatever Web site you use is free of viruses or other harmful items.

Since the Recovery Model of the WEM Database is set to "Full", there needs to be a scheduled task to perform Transaction Logs Backups and Full backups periodically. And, the Transaction logs should get truncated after performing the backup.

Here is a Microsoft URL discussing Recovery Models for more information: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models-sql-server

Here is a Microsoft URL discussing backing up Transaction Logs: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/transaction-log-backups-sql-server

Here is another Microsoft URL discussing Transaction Logs Truncation: https://technet.microsoft.com/en-us/library/ms189085(v=sql.105).aspx

***DISCLAIMER: Creating/modifying tasks in SQL should only be performed by a Database Administrator.***

---

Problem Cause

For WEM Database, SQL Transaction logs were not being backed up/pruned using SQL Maintenance tasks