SQL SERVER ERRORLOG FILE UTILIZING THE FREE SPACE I'm stuck up in one of the issue.
I'm Using SQL SERVER 2008 R2.
The SQL SERVER Log file is utilizing the disk space.
When ever I clear the space in the DRIVE, the SQL SERVER Error log file starts to utilize the free space.
Log file path is available in C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50. WINCC\MSSQL\Logs\ERRORLOG
Kindly, help me to resolve the issue.
You can close the existing log file by running
sp_cycle_errorlog
Which will create a new empty file
After that just delete the old log files
You should probably look what errors are being logged &amp; try and fix those so the new error log doesn’t fill up so fast
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-cycle-errorlog-transact-sql?view=sql-server-ver15