Home Forums SQL Server 2005 Administering The process cannot access the file because it is being used by another process. [SQLSTATE 42000] (Error 22022). The step failed. RE: The process cannot access the file because it is being used by another process. [SQLSTATE 42000] (Error 22022). The step failed.

  • December 18, 2013 at 2:26 am

    #1674312

    The error message indicates the SQL Agent error logfile is locked by another proces. This proces could be for example an Anti-Virus application. When this error occurs you can use "Proces Explorer" from sysinternals to examine all processes using a specific file.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **