Errorlog

I have a large errorlog file that seems to always be in use - can I
delete it or create a new one ?See sp_cycle_errorlog in the BOL
<af.at.work@.gmail.com> wrote in message
news:1154349669.831471.11590@.h48g2000cwc.googlegroups.com...
>I have a large errorlog file that seems to always be in use - can I
> delete it or create a new one ?
>|||af.at.work@.gmail.com wrote:
> I have a large errorlog file that seems to always be in use - can I
> delete it or create a new one ?
>
Lookup 'sp_cycle_errorlog' in Books Online
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||sp_cycle_errorlog did the trick...
af.at.work@.gmail.com wrote:
> I have a large errorlog file that seems to always be in use - can I
> delete it or create a new one ?|||Hello,
Incase if you are not restarting the SQL Server service or restaring the
server then probably monthly you can schedule a SQL Agent job to run the
command sp_cycle_errorlog to create a new log file. This will help you to
open the log file faster when required.
Thanks
Har
SQL Server MVP
<af.at.work@.gmail.com> wrote in message
news:1154350467.021510.127940@.i3g2000cwc.googlegroups.com...
> sp_cycle_errorlog did the trick...
>
> af.at.work@.gmail.com wrote:
>> I have a large errorlog file that seems to always be in use - can I
>> delete it or create a new one ?
>