April 10, 2012 at 7:55 am
SQL Server 2005 (64) 9.0.4053
I am running into an on and off issue that I can't figure out. I have a maintenance task setup to run after our nightly backups finish to clean up backups older than two days. Somedays it removes the files and somedays it doesn't and I just can't figure out why this happening. I have been removing them manually so our backups can finish without running out of space. Over the weekend my backups failed because I ran out of space. There were some backups that were 3-4 days old that it had not removed. This is the syntax that the task is executing:
EXECUTE master.dbo.xp_delete_file 0,N'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup',N'bak',N'04/08/2012 08:02:53'
The output log says process finished with success but the file didn't get deleted.
After searching a lot more on this site it seems there is a bug with some of the maintenance tasks.
Are there any work arounds for them?
Thank you.
April 12, 2012 at 8:49 am
I ended up figuring it out from posts on this site. I added a \ to end of the path and now it is working correctly.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply