How to set SQL Server Error Log File size

In my situation, SQL Server Error log file started overflowing after I enabled the Broker interface to my one of the Database, in this situation to solve log file growing in GBs I searched the web and me got many results in chunks, so by combining all the things solved my problem and same is listed below. How to Recycle SQL Server Error Log file without restarting SQL Server Service Recycle SQL Server ErrorLog File using DBCC ERRORLOG Command Recycle SQL Server Error Log File using SP_CYCLE_ERRORLOG System Stored Procedure…

Read More