clean up maintenance plan failing because it can't access log file

Question

clean up maintenance plan failing because it can't access log file

jshurak

SSCrazy

Points: 2763
More actions
August 8, 2011 at 6:17 am

#255468

Much like the subject says, my cleanup job is failing because it can't access the log file it generates. The exact error is :
The process cannot access the file 'E:\\Program Files\\Microsoft SQL Server\\MSSQL10.MyServer\\MSSQL\\Log\\TJUHMaint_Cleanup files_20110808075201.txt' because it is being used by another process.
What other process could be accessing this

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 1

irritating those type of errors! You don't have it open in another mapped file/drive?

I usually try to rename a file in this type of situation and see what info is generated. Your delete isn't trying to delete the log file it's actually writing? I know it sounds silly but I admit to doing this once myself.

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

jshurak SSCrazy Points: 2763 More actions · Answer 2

Hi, I initally checked to see if it was trying to delete its own log, but no, this job deletes old backup files. Strange.

Shark Energy SSCrazy Eights Points: 8389 More actions · Answer 3

So definitely no "Keep logs for x amount of days" in there?

jshurak SSCrazy Points: 2763 More actions · Answer 4

nah, we have a separate job to cleanup thos files

Jack Corbett SSC Guru Points: 184394 More actions · Answer 5

jshurak (8/8/2011)
Much like the subject says, my cleanup job is failing because it can't access the log file it generates. The exact error is :
The process cannot access the file 'E:\\Program Files\\Microsoft SQL Server\\MSSQL10.MyServer\\MSSQL\\Log\\TJUHMaint_Cleanup files_20110808075201.txt' because it is being used by another process.
What other process could be accessing this

You don't have the cleanup step trying to run in parallel with another step in the maintenance plan do you? Verify that you have a precedence constraint from the previous step in the maintenance plan to the clean up step.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question