Post reply

Is there a way to control SQL Server Log growth?

  • June 8, 2004 at 8:59 am

    #163884

    SQL Server Log grows to gigabytes. I need to control it. I have configured SQL Sever agent to keep 5 instances of sql server logs. Restarting SQL Server Agent or rebooting server will create new sql server log file. Is there any other way to control the growth of SQL Server log?

    Thanks

    HT

  • June 9, 2004 at 2:07 am

    #509593

    EXEC sp_cycle_errorlog

    his will do as it says and start a new error log when ran

     

  • June 10, 2004 at 2:27 am

    #509782

    you have to backup Log every 30 minutes ... this will empty the Log .. and the Log will grow with a small size


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

  • June 10, 2004 at 7:55 am

    #509861

    You can run 'DBCC errorlog' to recycle log. I schedule this to run everyday at midnight. I also configure SQL Server error logs to maximum logs to be 30.  

  • June 11, 2004 at 11:15 am

    #510122

    Thanks for your response. Sp_cycle_errorlog has helped me to resolve my issue.

     

    Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

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