Issue

The SQL transaction log file for the CPA database is continuously growing into several GBs and consuming excessive disk space on the server.

Cause

This issue usually occurs when the recovery model of the SQL database is set to Full. In this recovery mode, SQL Server continuously generates and stores transaction logs. Over time, the log file can grow significantly in size if regular log backups are not configured.

Resolution

To reduce the log file size and prevent it from growing continuously, change the recovery model from Full to Simple and shrink the CPA database log file.

Steps to Change the Recovery Model:

Step 1: Open SQL Server Management Studio (SSMS)

Launch SSMS and connect to the SQL Server instance.

Step 2: Open Database Properties

1. Locate the CPA database.

2. Right-click on the database and select Properties.

Step 3: Change Recovery Model

1. Go to the Options section.

2. Locate Recovery Model.

3. Change it from Full to Simple.

4. Click OK to save the changes.

Steps to Shrink the Database Log File:

Step 1: Open Shrink Option

1. Right-click on the CPA database.

2. Go to:

Tasks > Shrink > Database

Step 2: Shrink the Database

1. Click OK to proceed with the shrink operation.

2. Wait for the process to complete.

Expected Result

After changing the recovery model to Simple and shrinking the database:

• The SQL log file size should reduce significantly.

• The log file should stop growing continuously into several GBs under normal conditions.

• Disk space usage on the server will improve.