How to Enable Log Truncations when SQL Database is in Full Recovery 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 two registry values 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.

Follow these steps to add the registry value:

1. Open the registry table editor using the following command:

regedit

2. For agentless backup, navigate to the below key. Create the registry table value inside the VM that you want to backup. If the registry table key is not available, then create the complete key path.
• 32-bit OS:
• HKEY_LOCAL_MACHINE\SOFTWARE\Arcserve\Unified Data Protection\Engine\AFBackupDll
• 64-bit OS:
• HKEY_LOCAL_MACHINE\SOFTWARE\WoW6432Node\Arcserve\Unified Data Protection\Engine\AFBackupDll
3. Create the following two registry values and for both set the value to 1:

• dword value named BackupSQLLog4Purge
• dword value named ForceShrinkSQLLog
• The registry value is added.

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