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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-08 : 07:17:41
|
| denise writes "I want to create a new log with out stop/start the server because the current log is getting very big. I'm pretty new to sql server admin and have not done this before. What is the best way to do this? I read in the documentation an example: exec sp_cycle_errorlog. How do I run this using Enterprise Manager? Do users need to be out? Thanks for any help." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-11-08 : 07:23:13
|
| Don't run it from Enterprise Manager, use Query Analyzer instead. |
 |
|
|
|
|
|
sql server logs-running sp_cycle_errorlog