Edit

Fix excessive consumption of database space

Symptoms

The database space is consumed too fast during the Data Purge process or for any other reason.

Cause

The growing transaction log file causes the problem.

Solution

To resolve the issue for the databases running in the Always-On mode, enable regular transaction log backup in your workfusion database. This helps avoid the excessive growth of the log file.

For the detailed guide on setting the backup, see Use the Maintenance Plan Wizard.

If you don't run the database in the Always-On mode, follow the steps below:

1. Enable weekly or daily full or diff backups for the workfusion database.
2. Change the recovery mode to SIMPLE.

In the latter case, the transaction log is cleared after every transaction.