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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Recycling SQL Errorlog

Author  Topic 

sandesh_moghe
Constraint Violating Yak Guru

310 Posts

Posted - 2006-12-28 : 14:01:13
Hello All,

SQL Errorlog file on one of my production server is grown to 800MB.
I tried to recycle it but didnot create new file. (it is almost 24 hours)
What can be the reason?
Please note, as it is production box i can not recycle SQL.

Thanks in advance.

---------------------------
Sandesh - The Messenger

Kristen
Test

22859 Posts

Posted - 2006-12-28 : 14:18:53
sp_cycle_errorlog ??
Go to Top of Page

sandesh_moghe
Constraint Violating Yak Guru

310 Posts

Posted - 2006-12-28 : 14:23:44
Yes!

---------------------------
Sandesh - The Messenger
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-12-28 : 14:26:57
Well, its got to rename all the pre-existing logs - but I can't imagine that will take long.

Check there is spare disk space perhaps?

Presumably the job/person that executed sp_cycle_errorlog had sysadmin permissions?

Kristen
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-12-28 : 14:29:14
P.S. There are a few bits and pieces on SQLTeam - which might be relevant. Try a Google for:

site:sqlteam.com sp_cycle_errorlog

Kristen
Go to Top of Page

sandesh_moghe
Constraint Violating Yak Guru

310 Posts

Posted - 2006-12-28 : 18:29:05
Thanks Kristen
I think you are right, due to space crunch it is not able to create new file and rename older.
I have searched on this site, but couldnt find any relevant information.


---------------------------
Sandesh - The Messenger
Go to Top of Page

sandesh_moghe
Constraint Violating Yak Guru

310 Posts

Posted - 2006-12-29 : 01:28:28
Yes it worked. Due to space issue, SQL couldn't create new error log file. I stopped SQL, moved big errorlog file to another location and started SQL. It created errorlog file (with empty errorlog.1 as old file was moved.)
After this when i recycled errorlog, it created new file.
Thanks a lot Kristen.

---------------------------
Sandesh - The Messenger
Go to Top of Page
   

- Advertisement -