Transaction log FULL error in SQLServer when attempting to Sync Technopedia

Summary

Synopsis

If Transaction Log becomes full on SQL Server... this will cause Technopedia Sync to Fail.

Updater log indicates the following:
Error: The transaction log for database 'BDNA_PUBLISH_####' is full due to 'ACTIVE_TRANSACTION'.

Discussion

Transaction Logs for databases need to be shrunk. To resolve this, you can do the following [in SQL Server 2008] (to clear up all BDNA DB Transaction Log space):

Note: You should backup the Transaction Log before proceeding [those steps are not below].

1. In SQL Server Mgt Studio? select each BDNA database (separately)...
   1. Right Click.. select Properties
   2. Select Options
   3. Ensure recovery mode = ?Simple?
   4. Click OK
   5. Right click the Database again
   6. Select Task > Shrink > Files
   7. In ?File Type:?? select ?Log?
   8. Click OK
   9. Repeat steps above for each BDNA database

-----------------------------------------------------------------------------------------------------
Alternatively.. you could use SQL directly?
ALTERDATABASE mydatabase SET RECOVERY SIMPLE
DBCC SHRINKFILE (mydatabase_Log, 1)