August 30, 2006 at 3:02 pm
On an original install of SQL 2005, not an upgrade, where is the value for the number of error logs to keep?
That is, other than Right-Clicking on SQL Server Logs and choosing Configure. Is the value kept in a table? I don't see a registry value like SQL 2000 used for a Default instance HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\NumErrorlogs
Looking for the value to be in the registry or a table, but can't find it.
Any help would be greatly appreciated.
August 30, 2006 at 3:41 pm
found this on Microsoft:
http://support.microsoft.com/?kbid=196909
which has the following key point, By default, this key is absent.
The new registry key that you can set is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\NumErrorLogs
By default, this key is absent. The value is of the REG_DWORD type. Modify the value to the number of logs that you want to maintain.
Hope this helps.
August 30, 2006 at 3:44 pm
I should also point out that if this is a 1 off thing (you are not trying to script it for multiple instances) you can expand management, right click on sql server error logs, and configure. this will also setup the # of error logs to maintain (between 6 and 99)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply