Post reply

SQL Error Log Size

  • February 25, 2015 at 7:17 pm

    #315684

    Hi Experts,

    What is the default size of SQL error log ? How can i find the current size of SQL Server log and how can i modify it?

    TIA

  • February 26, 2015 at 2:13 am

    #1780138

    Hi,

    As to my knowledge there is no defined size of SQL Server Error Log file. Sql Server will keep on using the same file until the server is restarted or sp_cycle_errorlog is called.

    I have done the following two things to manage the log file in my server:

    1. Made a Job which is scheduled daily to execute sp_cycle_errorlog to change to the next file.

    2. Changed the maximum number of error log files to 99. (so as to hold log worth 99 days)

    Regards,
    Shafat Husain
    🙂
    And Your Lord Never Forgets...!! (64:19 -- Quran)

  • February 26, 2015 at 4:18 am

    #1780169

    Yeah, it just grows. There isn't a default size. Best to follow an approach similar to what Shafat suggests above.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

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

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