errorlog

I have SQL 2000 with sp3. I can't recycle the errorlog. I have already
tried sp_cycle_errorlog and it does not do it. The errorlog is up to
300 MB. Any suggestions short of stopping/starting SQL ?
Raziq.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!Raziq Shekha wrote:
> I have SQL 2000 with sp3. I can't recycle the errorlog. I have
> already tried sp_cycle_errorlog and it does not do it. The errorlog
> is up to 300 MB. Any suggestions short of stopping/starting SQL ?
Have you tried DBCC ERRORLOG?
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks Sebastian, yes I have already tried dbcc errorlog it is also not
working. Any other ideas?
Raziq.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Raziq Shekha wrote:
> Thanks Sebastian, yes I have already tried dbcc errorlog it is also
> not working. Any other ideas?
No idea. It should be immediate. Do you check your file size in Explorer or
SQL EM?
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Raziq Shekha wrote:
> I have SQL 2000 with sp3. I can't recycle the errorlog. I have
> already tried sp_cycle_errorlog and it does not do it. The errorlog
> is up to 300 MB. Any suggestions short of stopping/starting SQL ?
Ensure that your ERRORLOG.* files do _not_ have read only attribute set.
Markku