I have several databases on a server. This is the only database backup that fails.
It fails from maintenance plans (full backup and transaction log backups)
It fails from T-SQL BACKUP commands.
Here is what ERRORLOG says:
2009-12-04 06:00:41.03 spid57 Internal I/O request 0x6F21C9C0: Op: Write, pBuffer: 0x05670000, Size: 983040, Position: 112919040, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0x6BB0200, OffsetHigh: 0x0, m_buf: 0x05670000, m_len: 983040, m_actualBytes: 0, m_errcode: 2, BackupFile: d:\SQLData\MSSQL\BACKUP\DBName\DBName_tlog_200912040600.TRN 2009-12-04 06:00:41.03 backup BACKUP failed to complete the command BACKUP LOG [DBName] TO DISK = N'd:\SQLData\MSSQL\BACKUP\DBName\DBName_tlog_200912040600.TRN' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
I can write the database backup to a UNC path off the server.