March 1, 2016 at 8:33 am
Hi,
I am new to the lite speed backups.
We have 2 backup jobs using litespeed. Both of them are full backup job just seperate databases.
One job started failing recently
Native Size: 11.06 MB Backup Size: 0.21 MB Processed 1312 pages for database 'db', file '' on file 1. Processed 1 pages for database 'db', file Unexpected termination on thread: 0, Return code: x2DB4 [SQLSTATE 42000] (Error 111700). The step failed.
The other backup job is running fine daily but this is failing from 2 weeks.
Any suggestion will be helpful. SQL Server 9.0.5000
March 1, 2016 at 10:37 am
Has the database that is failing its backups passed DBCC?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 1, 2016 at 3:36 pm
Just noticed that log space has restricted growth. Increased the size and run the dbcc check db. No errors found
March 2, 2016 at 9:17 am
After increasing the log file size the backup job started working normally.
I wondered how the dbcc check db ran with out errors.
Previously when there is no space for the growth, I noticed it generated dump files and dbcc check db failed
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply