Transaction Log for Database is Full

Modified on Tue, 08 Jan 2013 11:59 AM by russellc@dundas.com — Categorized as: Errors, Support, Troubleshooting


Error Message

The transaction log for database 'Dundas_Dashboard_DataStore_version' is full.

Symptoms

When logging in or using Dundas Dashboard, you receive an error similar to:
The transaction log for database 'Dundas_Dashboard_DataStore_version' is full.

Cause

The following article contains more information about this error:
A transaction log grows unexpectedly or becomes full on a computer that is running SQL Server

Resolution

There are different ways to resolve the error. One way is to set the Recovery model to ‘Simple’. You can find more details about Recovery models here:
Recovery Models (SQL Server)

However, if you want to keep the recovery model set to ‘Full’, you will need to manage your transaction log space, as described here:
Managing the Transaction Log

Related topics