THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Tibor Karaszi

Managing the errorlog file

This blog has moved! You can find this content at the following new location:

Published Thursday, October 22, 2015 10:19 AM by TiborKaraszi



jeff_yao said:

Set limit for the log file size is actually an ideal method, which I explained here:

This method will apply to pre-sql2012 versions, the only thing you need to do is to run it daily in a sql job.



October 22, 2015 12:47 PM

Scott Duncan said:

I run a job that copies all ERRORLOG files to the backup folder before cycling the ERRORLOG. Scheduled for daily or weekly and on SQL Agent Startup. Copies are kept on disk for 20 days by default.

October 22, 2015 3:26 PM

123 said:">">">">

July 1, 2018 11:59 PM

hzx said:


July 12, 2018 12:01 AM
New Comments to this post are disabled
Privacy Statement