Clear SQL Server Log Files

ArticleDirectory

• Solution 1: Delete log files
• Solution 2: Limit the log file size

Solution 1: Delete log files

Steps:

1. Split Database Enterprise Manager --- server --- database --- Right-click --- detach Database

2. Delete log files

3. Attach Database Enterprise Manager --- server --- database --- Right-click --- attach Database

Note:

1. "Disconnect other database connections" before separation. For details, refer to SQL Server database separation and additional

2. Although the log file (. LDF) is deleted, this option is still displayed when it is attached. Therefore, you need to delete the log file, for example:

Solution 2: Limit the log file size

Select database --- Right-click Properties --- file options -- auto-increment button to set the limit on file growth: