Clear SQL Server logs

1. Right-click the database to which logs are cleared, such as "TestDB", and click [new query (Q)]
2. Enter the following SQL statement. "TestDB" indicates the database name.

Dump transaction TestDB WITH NO_LOG

3. Execute the SQL statement. After successful execution, continue with the following operations:

4. Right-click the database node and choose [task (T)]-> [shrink (S)]-> [file (F)]

5. in the displayed "shrink file" dialog box, select "file type (T)" as "log ", select "shrink operation" and "re-organize the page (O) before releasing unused space )"

6. In the "shrink file to (K)" text box, enter the minimum size value as prompted, and click [OK.