Thursday, March 22, 2012

change default errorlog retention

How can I save more errorlogs for SQL Server. Right now i believe the
default is 1 current and 6 archive logs.
How can I change it to 10 or 20 error logs ?Hi
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\NumErrorLogs
registry entry of DWORD data type
(path may change if you have a named instance)
By default the key is not here.
BEWARE: Incorrectly changing the registry may result in your system becoming
unusable. Test your actions on a non-critical installation before you do it
on a critical system.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:edltj$5aFHA.720@.TK2MSFTNGP15.phx.gbl...
> How can I save more errorlogs for SQL Server. Right now i believe the
> default is 1 current and 6 archive logs.
> How can I change it to 10 or 20 error logs ?
>|||Right click on SQL Server Logs in Enterprise Manager (under the Management
folder) and select Configure. You can select the number of logs there.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:edltj$5aFHA.720@.TK2MSFTNGP15.phx.gbl...
> How can I save more errorlogs for SQL Server. Right now i believe the
> default is 1 current and 6 archive logs.
> How can I change it to 10 or 20 error logs ?
>

No comments:

Post a Comment