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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-30 : 11:04:56
|
Mike writes "When I installed SQL Server on our live server it had the default six archive errorlogs. Recently somehow, it has not been reinitializing the current errorlog correctly, when using sp_cycle_errorlog. It reads in the current errorlog that the errorlog has been reinitialized, yet all the previous details are still in the same errorlog. The file ERRORLOG.1 is not written to. After running sp_cycle_errorlog several times, ERRORLOG.3 to ERRORLOG.6 have subsequently been deleted, as expected each time one of these became the oldest archive. Currently, there is only ERRORLOG and what was once ERRORLOG.2 is ERRORLOG.6 . This is because ERRORLOG.1 is not being created and therefore no new logs have been created to retain the six archives.
I have searched all over the web but the only information there is, is that which states that sp_cycle_errorlog just executes dbcc errorlog - which is not documented. Also, that a registry entry can be added to increase no. of errorlogs. However, this is not the problem, because the current log is not being written to ERRORLOG.1 anyway.
I can't stop and start the server because it needs to stay online
Please help
Mike" |
|
|
|
|
|
Errorlog Purging