May 5, 2003 at 12:52 pm
I've been asked to limit the size of a SQL 2K error log. Is this possible? I haven't been able to find anything on this.
Thanks in advance,
Paul
May 5, 2003 at 1:05 pm
Generally, SQL Server errorlog files are quite small in term of size. Why they want to do this?
You could set quota to log folder to SQL Server service account.
May 5, 2003 at 1:06 pm
there are couple of ways you can do that:
1. Restart sql server (ruled out i guess)
2. U can run sp_cycle_errorlog, but the number of versions will be 6 only. to change the number of versions you need to edit the registry to have more versions. U can read more about it in books online.
May 5, 2003 at 1:39 pm
You can always back them up or archive them to a seperate location.
quote:
U can run sp_cycle_errorlog, but the number of versions will be 6 only.
John Zacharkan
John Zacharkan
May 5, 2003 at 2:11 pm
Anyone using sp_cycle_errorlog and if why?
Have heard about a site with a 'BIG' errorlog which did not reset but otherwise never experienced any problems. The source of this info was'nt to reliable either.
May 5, 2003 at 3:49 pm
I use it. Don't want to wait any longer to load couple MB of data when I just want to read most recent entries in the log.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply