0 Replies Latest reply on Jan 23, 2009 10:29 AM by normanzhang

    Limit SQL Error Log Size

    normanzhang

      I'm running NPM v8.5.1 on SQL 2005 Express Server. When DB reaches 4GB, Orion can't write to it anymore. It balloons

      C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

      causing it to take up disk space. Is there a way to limit log at certain size either by

      * overwrite old entries
      * rotate log

      I googled http://msdn.microsoft.com/en-us/library/ms182512.aspx, but not sure how to apply it to a script. Can someone please give me few pointers?