Skip to content

Latest commit

 

History

History
40 lines (33 loc) · 1.9 KB

File metadata and controls

40 lines (33 loc) · 1.9 KB
title Configure SQL Server Error Logs | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-non-specified
ms.prod_service database-engine
ms.service
ms.component configure-windows
ms.reviewer
ms.suite sql
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic article
f1_keywords
sql13.swb.configurelogs.configureerrorlogs.f1
ms.assetid 03f0d463-9b0b-4af9-a853-da936d75e5af
caps.latest.revision 18
author MikeRayMSFT
ms.author mikeray
manager craigg
ms.workload On Demand

SCM Services - Configure SQL Server Error Logs

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] This topic describes how to view or modify the way [!INCLUDEssNoVersion] error logs are recycled.

To 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 click Configure.

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

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

    Maximum number of error log files
    Specify the maximum number of error log files created before they are recycled. The default is 6, which is the number of previous backup logs [!INCLUDEssNoVersion] retains before recycling them.