###### Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

Deciding to stick with EE.

Mohamed Asif

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
###### Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

# SQL 2008 Transaction Log Backup Failure

Microsoft SQL Server 2008
Hi,

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
Duration: 00:01:44
Status: Warning: One or more tasks failed.
Details:
Back Up Database (Transaction Log) (UPMSQL01) Backup Database on Local server connection
Databases: PMSQL03
Type: Transaction Log
Append existing
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''

GO
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

GO

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.

Thanks

Paul