问题描述:

I have one job to recycle error log every night and it is failing every night with the below error-

Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG' to 'D:\Program

Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG.1'

due to OS error '32(The process cannot access the file because it is

being used by another process.)'. A process outside of SQL Server may

be preventing SQL Server from reading the files. As a result, errorlog

entries may be lost and it may not be possible to view some SQL Server

errorlogs. Make sure no other processes have locked the file with

write-only access." [SQLSTATE 42000] (Error 17049) DBCC execution

completed. If DBCC printed error messages, contact your system

administrator. [SQLSTATE 01000] (Error 2528). The step failed.

Please advice how to find and kill the process which is using the error log file.

相关阅读:
Top