Backup Log is terminating abnormally.

Applies to: Microsoft SQL Server 2000 Standard Edition
 

Message.


Examining the SQL Server error log of a Microsoft SQL Server 2000 instance we found the following error:

Date 10/20/2008 12:08:13 PM
Log Job History (Backup - Voice- TLog)

Step ID 1
Server SRV02
Job Name Backup - Voice - TLog
Step Name 1
Duration 00:09:00
Sql Severity 16
Sql Message ID 3013
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: DOMAIN\Username. 10 percent backed up. [SQLSTATE 01000] (Message 3211) 20 percent backed up. [SQLSTATE 01000] (Message 3211) 30 percent backed up. [SQLSTATE 01000] (Message 3211) 40 percent backed up. [SQLSTATE 01000] (Message 3211) 50 percent backed up. [SQLSTATE 01000] (Message 3211) 60 percent backed up. [SQLSTATE 01000] (Message 3211) 70 percent backed up. [SQLSTATE 01000] (Message 3211) Write on 'LogicalBackupDevice_Voice' failed, status = 112. See the SQL Server error log for more details. [SQLSTATE 42000] (Error 3202) BACKUP LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.


Problem Description.

We were trying to perform a transaction log backup to disk and it failed.  We got the above error message in the SQL Server error log.

Cause.

There could be many causes to this error, but in this case there was not enough space on disk to create the transaction log backup.

Solution.

Either free some space or change the disk drive where the backup log is being created.

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.