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\MSSQLServer\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 ?
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment