当前位置: 动力学知识库 > 问答 > 编程问答 >

sql server - Unable to Recycle Error log

问题描述:

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.

分享给朋友:
您可能感兴趣的文章:
随机阅读: