I think that the people that answered with the 3rd option should have their answers made correct. This was a trick question. There are multiple ways to do this. Here are some I found with a Google Search.

INCREASE THE NUMBER OF ERRORLOGS THAT SQL SERVER MAINTAINS

There are two methods for adding the number of errorlogs that SQL Server

will maintain: using SQL Enterprise Manager (SEM) or the extended stored

procedure, xp_regwrite. Exercise caution when using the xp_regwrite

extended procedure, however, as it will modify the registry. Before

attempting to use this procedure, you should first back up the server's

registry

and thoroughly test the procedure.

Option 2:

1. Open Query Analyzer.

2. Run the following command to retrieve the current number of

errorlogs that SQL Server will maintain:

exec master..xp_regread N'HKEY_LOCAL_MACHINE',

N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',

N'NumErrorlogs'

3. Run the following command to update the number of errorlogs that SQL

Server will maintain where x is the number of logs desired:

exec master..xp_regwrite N'HKEY_LOCAL_MACHINE',

N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',

N'NumErrorlogs',

'REG_DWORD', x

4. Run the following command to verify that the number of errorlogs has

been changed to the value used in the previous command:

exec master..xp_regread N'HKEY_LOCAL_MACHINE',

N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',

N'NumErrorlogs'

5. Run the following command multiple times to add errorlogs (but not so

many times that you cycle out the errorlogs containing important

information):

exec master..sp_cycle_errorlog

1429 » How do I increase the number of SQL Server error logs?

To increase the number of error logs, use Regedt32 to navigate to:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

On the Edit menu, Add Value name NumErrorLogs, as a type REG_DWORD. In the DWORD Editor, click the Decimal Radix and enter a number greater than 7.

Wendy Johnson