Post reply

How to change the settings for for log files in log file viewer

  • February 14, 2014 at 12:40 pm

    #304147

    I navigate to Management/SQL Server Logs and open log file viewer and noticed that the current file is very large with billions of records. Is there a way I can get it to archive more often. the next file ended on 11/11/2013

  • February 14, 2014 at 1:45 pm

    #1689210

    On a nightly basis you can run sp_cycle_errorlog (http://technet.microsoft.com/en-us/library/ms182512.aspx)

    And then change the log retention to 30 days or so (or more depending on your needs).

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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