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
Wendy Schuman