|
Home > Archive > MS SQL Server > November 2006 > is there a way to truncate server logs
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
is there a way to truncate server logs
|
|
| Dan D. 2006-11-16, 7:12 pm |
| We haven't rebooted the server in months and now when I go into EM,
Management, and SQL Server Logs it takes forever for the logs to display. Is
there a way to roll over to another log or truncate the existing log file so
it won't take so long to display the logs?
Thanks,
--
Dan D.
| |
| Tracy McKibben 2006-11-16, 7:12 pm |
| Dan D. wrote:
> We haven't rebooted the server in months and now when I go into EM,
> Management, and SQL Server Logs it takes forever for the logs to display. Is
> there a way to roll over to another log or truncate the existing log file so
> it won't take so long to display the logs?
>
> Thanks,
See "sp_cycle_errorlog" in Books Online
--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
| |
| Dan D. 2006-11-16, 7:12 pm |
| Now that is a handy little command. Thanks Tracy.
--
Dan D.
"Tracy McKibben" wrote:
> Dan D. wrote:
>
> See "sp_cycle_errorlog" in Books Online
>
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>
|
|
|
|
|