Transaction log backups failing

[Former Member]

We have recently patched the system and it appears that since then, the

backups do not work via the maintenance plans we configured. We have a

few maintenance plans in place:

1. Clear backup files from staging area older than 2 days (this

executes OK daily)

2. Backup databases (RP1, msdb, model, master) to staging area (should

execute daily but not OK)

3. Clear Transaction log backup older than 5 days from staging area

(this runs OK daily)

4. Backup transaction log file to staging area (should run every 20

minutes but isnt working)

The error message for the transaciton log backup is:

Executing the query "EXECUTE master.dbo.xp_delete_file

0,N'E:\\RP1_Redo'..." failed with the following error: "xp_delete_file

() returned error 2, 'The system cannot find the file specified.'".

Possible failure reasons: Problems with the query, "ResultSet" property

not set correctly, parameters not set correctly, or connection not

established correctly

I have found content related on the internet but none seems to be valid for our situation.

Thanks and Regards

Ray

[Sriram2009]

Hi Ray

Try to recreate the new maintenance plans and then few findings

1. In the both backups (Backup of DB & Transaction Log) you can select only the’ RP1’ database alone not for the entire MS Sql stand DB(Master, MSDB & model). Full DB backup you can take weekly or monthly
2. Every day the ‘Backup Database’ completed successful (without any error) then start the transaction log backup

Thanks & Regards

Sriram

[former_member184473]

Hello Ray,

You mentioned you patched the system, which version was implemented and which version is currently implemented into the system?

Also, if you recreate the plans, do you observe this issue?

And, check the details of your maintenance plan.

Regards,

Eduardo Rezende

[former_member206552]

hi ray,

have you tried these steps ?

http://danieladeniji.wordpress.com/2011/12/16/microsoft-sql-server-xp_delete_file-error-2/

best regards

marius