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

"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
>