Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Problems on my maintenance plan execution

Author  Topic  goffie Starting Member 1 Post Posted - 2009-04-23 : 10:00:39 I have a maintenance plan set up to do a number of maintenance tasks e.g full backup, check database integrity, reorganize indexes e.t.c. Some parts of the plan have been failing with the message "The process cannot access the file 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\LOG\\ MaintenancePlan_Subplan_1_20090422220327.txt' because it is being used by another process." The task will normally show that it was able to execute once then tried to re execute two, or three times and failed, i don't know why this happens, why it tries to re-execute, it looks like the fist time the process executes causes the subsequent execution of the same process to fail as the first process will still be using the file. Any ideas what's causing this and how to resolve? Sorry guys i am really new on Database Administration. I use SQL 2005