It has often been observed that error logs in SQL server increase to large values. Further there is not way to set limit on size of log file from SSMS.
Below is a very nice article to set the limits on the size of error log file along with the number of error log files.
https://www.sqlskills.com/blogs/paul/limiting-error-log-file-size-in-sql-server-2012/
No comments:
Post a Comment