Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Increase Nbr Of Error Logs SP ???

Status
Not open for further replies.

JayKusch

MIS
Oct 30, 2001
3,199
US
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.

Thanks

J. Kusch
 
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.


DARN!!!

Thanks

J. Kusch
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top