Home Forums SQL Server 2008 SQL Server 2008 - General How can I leave only only 10 days of SQl Server logs in sql server?‌‌ RE: How can I leave only only 10 days of SQl Server logs in sql server???

  • March 1, 2018 at 2:32 pm

    #1981713

    almirfiorio - Thursday, March 1, 2018 2:27 PM

    Michael L John - Thursday, March 1, 2018 1:51 PM

    Do you want 10 DAYS, or 10 log files? 
    If you are recycling the logs on a nightly basis, then going into settings is the way to do it as Sue_H suggested. 
    If you are not recycling the logs, then you may need to implement that as well as what Sue said.

    im want only 10 days of log

    So as Michael and I are both getting at is you can:
    Daily you can execute sp_cycle_errorlog. You can create a job to do this at midnight (or whatever time) every day so the log is cycled every day.
    And then set max files to 10.

    Sue