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

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

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

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

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

Troubleshooting
Research
Professional Opinions
Ask a Question
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

Avatar of the1paulcole
the1paulcoleFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL Server 2008
5 Comments1 Solution2125 ViewsLast Modified:
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
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''

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
ASKER CERTIFIED SOLUTION
Avatar of ProjectChampion
ProjectChampionFlag of United Kingdom of Great Britain and Northern Ireland image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answers