Skip to content

Latest commit

 

History

History
39 lines (26 loc) · 1.98 KB

scm-services-configure-sql-server-error-logs.md

File metadata and controls

39 lines (26 loc) · 1.98 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords
Configure SQL Server error logs (SQL Server Configuration Manager)
Learn about error log recycling. See how to set a maximum log file size and how to set the number of previous log files that SQL Server backs up and archives.
rwestMSFT
randolphwest
07/26/2024
sql
configuration
how-to
sql13.swb.configurelogs.configureerrorlogs.f1

SQL Server Configuration Manager: Configure SQL Server error logs

[!INCLUDE SQL Server]

This article describes how to view or modify the way [!INCLUDE ssNoVersion] error logs are recycled.

Open the Configure SQL Server Error Logs dialog box

  1. In Object Explorer, expand the instance of SQL Server, expand Management, right-click SQL Server Logs, and then select Configure.

  2. In the Configure SQL Server Error Logs dialog box, choose from the following options.

    • Log files count

      Limit the number of the error log files before they are recycled

      Check to limit the number of error logs created before they're recycled. A new error log is created each time an instance of [!INCLUDE ssNoVersion] is started. [!INCLUDE ssNoVersion] retains backups of the previous six logs, unless you check this option, and specify a different maximum number of error log files.

      Maximum number of error log files

      Specify the maximum number of archived error log files created before they're recycled. The default is 6, not including the current one. This value determines the number of previous backup logs that [!INCLUDE ssNoVersion] retains before recycling them.

    • Log file size

      Maximum size for error log file in KB

      You can set the size amount of each file in KB. If you leave it at 0, the log size is unlimited.