Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
1fred
Posting Yak Master
158 Posts |
 Posted - 2002-08-15 : 17:11:04
|
| Is there any mean to remove the old SQL Server logs under management/SQL Server Logs/Thanks |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-08-15 : 18:49:45
|
| You can use sp_cycle_errorlog to cycle the log if its getting too big. The actual number of logs is controlled by a registry keyHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServeradd a new DWORD value called NumErrorLogs and set the decimal value to the number of logs you want e.g. 3 (the default is 6 when this value is not present)You can just delete old error logs in the file system.HTHJasper SmithEdited by - jasper_smith on 08/15/2002 18:51:27 |
 |
|
|
|
|
|
Remove Sql logs