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 |
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
 Posted - 2007-01-10 : 18:04:04
|
| this file is getting upto 110GIG why? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-10 : 18:09:04
|
| Because you have a lot of events being sent to it. I would schedule a job to cycle the error log to keep it more manageable. sp_cycle_errorlogTara Kizer |
 |
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2007-01-10 : 18:11:06
|
| our automailing system failed and there for the logs increased highly, is there a way to clear the error log? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-10 : 18:15:18
|
| Umm, yes. Please see my last post. You can keep cycling it until the large file is gone.Tara Kizer |
|
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2007-01-10 : 18:16:33
|
| sorry i posted before i read ursthanx |
|
|
|
|
|
|
Error.log too large