I am in the process of setting up transaction log backups, every 45 minutes to a network share (a first for me). Until the last 2 backups, everything was running fine. Now, they seem to be sporadically failing with the following error:
Maintenance Plan: Trans Log Backup
Status: Warning: One or more tasks failed.
Back Up Database (Transaction Log) (UPMSQL01) Backup Database on Local server connection
Type: Transaction Log
Task start: 2010-07-01T17:15:00.
Task end: 2010-07-01T17:16:45.
Failed:(-1073548784) Executing the query "BACKUP LOG [PMSQL03] TO DISK = N'\\\\qmtad01\\pm_db_..." failed with the following error: "The operating system returned the error '64(failed to retrieve text for this error. Reason: 1815)' while attempting 'FlushFileBuffers' on '\\\\qmtad01\\pm_db_backup$\\transaction logs\\PMSQL03\\PMSQL03_backup_2010_07_01_171500_6874874.trn'.
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.
100 percent processed.
Processed 161496 pages for database 'PMSQL03', file 'PMSQL03_Log' on file 1.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:EXECUTE master.dbo.xp_create_subdir N''\\qmtad01\pm_db_backup$\transaction logs\PMSQL03''
BACKUP LOG [PMSQL03] TO DISK = N''\\qmtad01\pm_db_backup$\transaction logs\PMSQL03\PMSQL03_backup_2010_07_01_171500_6874874.trn'' WITH NOFORMAT, NOINIT, NAME = N''PMSQL03_backup_2010_07_01_171500_6718618'', SKIP, REWIND, NOUNLOAD, STATS = 10
The backup file is appearing on the network share, the location can be accessed and pinged fine, yet the report comes back as failed and the transaction log is not being cleared which will definitely cause problems in the not so distant future.
Does anyone know what could be causing this sudden failure? I will be switching over to SIMPLE mode shortly as I don't feel comfortable leaving this over-night as the log file does fill up fairly fast.