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 |
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 ?? |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2006-12-28 : 14:23:44
|
Yes!---------------------------Sandesh - The Messenger |
|
|
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 |
|
|
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_errorlogKristen |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2006-12-28 : 18:29:05
|
Thanks KristenI 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 |
|
|
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 |
|
|
|
|
|