## Answer 1. Set "DeleteSysLogs" in "[BackgroundService.json](/en/manual/background-service-json)" 1. Delete with SQL. This page explains. --- ## Overview The procedure to delete Pleasanter's "log". Depending on usage, logs may become bloated, so please consider deleting logs as necessary. Deleting logs will not affect the operation of Pleasanter. ## Notes 1. This procedure involves direct manipulation of the database, so it is dangerous. We strongly recommend that you take a "[Backup](/en/manual/faq-backup-and-restore)" in advance. ## Operation Procedure 1. Log in to the server on which Pleasanter is installed. 1. Launch "[SSMS](/ja/manual/install-sql-server-management-studio)" (SQL Server Management Studio). 1. Expand "Databases" from "Object Explorer" and select "Implem.Pleasanter" → Right-click → Click "New Query". 1. Execute the following "1. SQL for deletion" to delete all logs. 1. Execute the following "2. SQL for confirmation after deletion" to confirm that the logs have been deleted. ## Sample code ### 1. SQL for deletion ##### SQL ``` truncate table "SysLogs"; ``` ### 2. SQL for confirmation after deletion ##### SQL ``` select top 1000 * from "SysLogs"; ``` ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/install-sql-server-management-studio">Install SQL Server Management Studio</a><span>10.01.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/background-service-json">Set Parameter: BackgroundService.json</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/faq-backup-and-restore">FAQ: How to backup and restore Pleasanter's DB data</a><span>08.14.2024 up</span></li> <li><a href="/en/manual/faq-backup-schedule">FAQ: I want to backup Pleasanter' DB data regularly (SQL Server)</a><span>12.19.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />