You can increase the number of error logs SQL Server will maintain by modifying your server's Registry. By default, SQL Server 7.0 maintains seven error logs-but you can increase this number. You cannot change the number of error logs maintained in SQL Server 6.5. To increase the number of error logs on your server, access the Registry key:

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer

Add the value NumErrorLogs with a data type of REG_DWORD and set its data to the number of logs you want to maintain on your server. You can also set this value by using the xp_regwrite extended stored procedure in SQL Server Query Analyzer. Use the following syntax:

xp_regwrite HKEY_LOCAL_MACHINE',

'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', 'NumErrorLogs','REG_DWORD', 20

GO

SQL Index

Main Index