Is there an system SP or XP that will increase the number of SQL Server Error Logs that are retained before they are recycled. I am aware of how to do it in EM just need to know if I can increase the default number, being 6.
Hmmmm .... Looks like there is no Holy Grail SP to accomplish this. Looks as if one must make a registry entry, in W2K at least, as described in this snipette ...
Set the maximum number of error log files to a value high enough that the error logs will not be overwritten. Error logs should only be overwritten after being archived or properly reviewed.
Set the maximum number of error log files to a number greater than 25000.
You cannot set the value through Enterprise Manager because Enterprise Manager does not allow you to set a value greater than 99. You should change the value by editing the registry directly.
If you are using a named instance (Microsoft SQL Server 2000 only), set the value NumErrorLogs in the registry key HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\[Instancename]\MSSQLServer to 25000 or greater.
If you are using a default instance (Microsoft SQL Server 2000 only), set the value NumErrorLogs in the registry key HKEY_LOCAL_MACHINE\Software\MSSQLServer\MSSQLServer to 25000 or greater.
If this entry is not present in your registry, the system defaults to keep six logs. To change the default, perform the following steps to add a new registry entry.:
1) Select Edit/Add Value.
2) Type 'NumErrorLogs'.
3) Select the REG_DWORD type.
4) Click OK.
5) Enter the number of error logs you wish to keep before SQL Server writes over them.
6) Click OK.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.