- backup db: Monday => Friday 21h00
- backup transaction log: every 30 min. every day
- rebuild index: Monday 2h15
This worked fine until 2 weeks ago.
The backup of the transaction log does not longer work after/during the rebuild index task.
Back Up Database Task (SQL-server\navision)
Backup Database on Local server connection
Databases that have a compatibility level of 70 (SQL Server version 7.0) will be skipped.
Databases: All user databases
Type: Transaction Log
Task start: 2015-07-06T03:00:02.
Task end: 2015-07-06T03:08:41.
Failed:(-1073548784) Executing the query "BACKUP LOG [db_name] TO DISK = N'E:\path\backup_transactionlog_name.trn' WITH NOFORMAT, NOINIT, NAME = N'backup_transactionlog_name, SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "Write on "E:\path\backup_transactionlog_name.trn' " failed: 112(error not found)
BACKUP LOG is terminating abnormally.
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Apperently the backup chain is broken
When I get this error, I change the the recovery from full to simple and back to full.
Afterwards I run a full backup and the situation works again until the next rebuild index task.
I don't think this has something to do with diskspace.
15 GB free space on the disk where the transactionlog backup can be created.
Transactionlogfile 27,5 GB (database 32 GB).
But of course I'm not sure.
Anyone an idea what the problem could be?