Troubleshooting › SQL truncation log cannot be truncated when database is in Full mode

SQL truncation log cannot be truncated when database is in Full mode

Symptom:

When the database is in the Full mode and a full database backup is performed, the SQL truncation log cannot be truncated.

Solution:

To resolve this problem, add a registry value to enable Arcserve UDP run the BACKUP LOG command to back up the transaction log. This command marks the space, which is already written to database file, as reusable.

Note: For an agentless backup, create the registry table value in the VM that you want to back up.

Follow these steps to add the registry value:

1. Open the registry table editor on the agent machine using the following command:

   regedit
   

2. Navigate to the following key:

   HKEY_LOCAL_MACHINE\SOFTWARE\CA\ARCserve Unified Data Protection\Engine\AFBackupDll
   

3. Create a dword value named BackupSQLLog4Purge and set its value to 1.

   The registry value is added.

The solution is in effect when the next purge job occurs.