SQL database backups fail with error "The transaction log for database 'Databasename' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases".

Problem

SQL database backups fail with error "The transaction log for database 'Databasename' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases".

Error Message

 

Backup job log shows:-

An error occurred on a query to database backuptest. The transaction log for database 'backuptest' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

Cause

 

Backup of SQL database fails with the above mentioned error message if the volume hosting the log files for the SQL database(s) runs out of space.

 

Solution

1. Connect to the SQL instance using SQL Management Studio.

Note: If it is SQL Express instance then SQL Management studio may not be installed by default. 'Microsoft SQL Server Management Studio Express' can be downloaded from the link below:

 http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

2. Go to properties of the database(s) to find out the location for log file for the database (FIG 1).

FIG 1
 

3. Browse to the volume hosting the log file and check the amount of free space. If the drive does not have sufficient free space required for the log file to grow then free up space on the drive by deleting unwanted data.

 
 

 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)