Post reply

How to maintain the Error Log size?

  • September 15, 2009 at 10:05 am

    #156219

    Hi,

    I have confgured log shipping in SQL Server 2005 and the backup copy & restore job runs every 15 mins. The error log in Primary & Secondary are filled up with messages Database backedup & log was restored.

    So is there any way to generate a new error log aftter the error log size reaches to some fixed size? If yes what will be the ideal size to keep the error log size?

  • September 15, 2009 at 10:24 am

    #1053946

    you can cycle your error log with;

    EXEC dbo.sp_cycle_errorlog

    http://msdn.microsoft.com/en-us/library/ms182512.aspx%5B/url%5D

  • September 15, 2009 at 11:24 am

    #1053985

    thanks,

    is there any way to generate a new error log aftter the error log size reaches to some fixed size?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply