How to clear Sqlserver database logs

Published: 2004-04-20

```html

Sqlserver Cleanup Database Method ①

Directly on our company's website, go to [Management Center] - [Business Management] - [mssql database] - select the corresponding ms-SqlServer database [Manage], and click [Clear Log] to clear the logs.

blob.png

Sqlserver Cleanup Database Method ②

Start the SqlServer client tool “Sql Query Analyzer”, select "Sql Server Authentication", enter Server Address, Database Login Name and Password, finally enter the following in the command box:

  dump transaction database_name with no_log


Finally, right-click and select Execute to complete.

```