Scripts for Windows Admins with focus on:
SQL, SCOM, VMWare and general Windows OS tasks
Monday, 18 July 2011
Increase number of ERRORLOGs
-- Increase number of ERRORLOGS to 20, change last value if needed
-- From http://support.microsoft.com/kb/196909 EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs', REG_DWORD, 20