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 |
|
tripodal
Constraint Violating Yak Guru
259 Posts |
 Posted - 2008-04-11 : 16:25:07
|
| After having months to years of uptime, the "current" sql log is in the dozens or hundreds of megabyes. Is there anyways to have this file roll over more frequently so that attempting to open it in EM does not take ... minutes to hours? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-11 : 16:35:28
|
| Yes,Use this SP: sp_cycle_errorlog. Make decision before you do that. |
 |
|
|
|
|
|
Enterprise Manager Current Sql Server Logs.