Summary
This article discusses how to resolve a transaction log full error.
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].
- In SQL Server Mgt Studio? select each BDNA database (separately)...
- Right Click.. select Properties
- Select Options
- Ensure recovery mode = ?Simple?
- Click OK
- Right click the Database again
- Select Task > Shrink > Files
- In ?File Type:?? select ?Log?
- Click OK
- Repeat steps above for each BDNA database
-----------------------------------------------------------------------------------------------------
Alternatively.. you could use SQL directly?
ALTERDATABASE mydatabase SET RECOVERY SIMPLE
DBCC SHRINKFILE (mydatabase_Log, 1)