File Size for SQL Server 2005 Error Log

Hello,
My SQL Server 2005 error log is getting very, very large... Like 4 GB in 4
days... How can I recycle my error log so that it doesnt' overrun my c:
drive. Also, if there's a way to move the error log from the c: drive to
another drive, that would also help.
Thanks.
Adam F. HarrisOn Mar 14, 5:39 pm, "Adam Harris" <a...@.jgo.com> wrote:
> Hello,
> My SQL Server 2005 error log is getting very, very large... Like 4 GB in 4
> days... How can I recycle my error log so that it doesnt' overrun my c:
> drive. Also, if there's a way to move the error log from the c: drive to
> another drive, that would also help.
> Thanks.
> Adam F. Harris
You will want to execute sp_cycle_errorlog periodically. I would
suggest scheduling a job that runs it as well.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Hello Enrique,
Ok, that sounds great, but I have no idea how to do that... Do you have a
website or documentation to do that?
Thanks.
Adam F. Harris
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1173921963.231488.253620@.b75g2000hsg.googlegroups.com...
> On Mar 14, 5:39 pm, "Adam Harris" <a...@.jgo.com> wrote:
>> Hello,
>> My SQL Server 2005 error log is getting very, very large... Like 4 GB in
>> 4
>> days... How can I recycle my error log so that it doesnt' overrun my c:
>> drive. Also, if there's a way to move the error log from the c: drive to
>> another drive, that would also help.
>> Thanks.
>> Adam F. Harris
> You will want to execute sp_cycle_errorlog periodically. I would
> suggest scheduling a job that runs it as well.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>