|   | ![]() |
|
My SQL Server errorlog has
switched several times and I've lost the evidence of a crash problem. How can I increase
the number of errorlogs to prevent this? With SQL 6.5 and below there is no way to increase the number. With SQL 7 you can by adjusting the following registry entry :- HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer DWORD NumErrorLogs = <xx> Alternatively you can add a startup stored procedure to SQL 6.x or 7.x that copies out and renames the previous errorlog every time SQL re-starts. |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.