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".

Article:TECH66220  |  Created: 2008-01-22  |  Updated: 2014-07-07  |  Article URL http://www.symantec.com/docs/TECH66220
Article Type
Technical Solution

Product(s)

Issue



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



 

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.

 

Supplemental Materials

SourceError Code
Value0xe0008492
Description

Database Query Failure. See the job log for details


SourceUMI
ValueV-79-65323-9002
Description

"The transaction log for database 'Databasename' is full"



Legacy ID



316784


Article URL http://www.symantec.com/docs/TECH66220


Terms of use for this information are found in Legal Notices