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: 2012-01-21 | | | Article URL http://www.symantec.com/docs/TECH66220 |
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
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
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.
|
|
| Source | Error Code |
| Value | 0xe0008492 |
| Description | Database Query Failure. See the job log for details |
| Source | UMI |
| Value | V-79-65323-9002 |
| Description | "The transaction log for database 'Databasename' is full" |
Related Articles
Legacy ID
316784
Article URL http://www.symantec.com/docs/TECH66220
Terms of use for this information are found in Legal Notices
Thank you.