June 14, 2017 at 10:07 pm
Hi Experts,
While recycling error log using command - DBCC Errorlog , I am facing the below error.
Any inputs/pointers to resolve the issue ?
June 15, 2017 at 2:06 am
chinna.sp3025 - Wednesday, June 14, 2017 10:07 PMHi Experts,While recycling error log using command - DBCC Errorlog , I am facing the below error.
Unable to cycle error log file from 'E:\Data\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG' to 'E:\Data\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG.1' due to OS error '5(Access is denied.)'. 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."Any inputs/pointers to resolve the issue ?
Any monitoring software that might have a lock on the file?
😎
June 15, 2017 at 2:41 am
How can I confirm the same with out installing any process monitor tools in the server , please advice
June 15, 2017 at 2:46 am
chinna.sp3025 - Thursday, June 15, 2017 2:41 AMHow can I confirm the same with out installing any process monitor tools in the server , please advice
You can use i.e. sysinternals process explorer
😎
June 15, 2017 at 10:37 am
June 19, 2017 at 10:50 pm
This was removed by the editor as SPAM
June 20, 2017 at 8:45 am
Does the account that is running SQL SERVER SERVICES have permissions to the Windows file or folder.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply