Clear MSSQL logs and set recovery simple

The database on the server has been using several log files for a long time.

I think we can discard the previous log files, so we can clean up the previous log files.

The problem I want to solve is that when the backup file is used for recovery

Do you want to use log files?

Check the information later. If not, use the simple data mode to save the space occupied by log files.

1. Open the query analyzer and enter the command


Dump transaction database name WITH NO_LOG


2. open the Enterprise Manager and right-click the database you want to compress -- all tasks -- shrink database -- shrink file -- Select log file -- select to shrink to XXM In the shrink mode, here we will provide a minimum number of M that can be reduced. Enter this number directly and click OK.

If you do not want it to become larger later
Use in SQL2000:
Right-click the database and choose Properties> Options> fault recovery> model> select simple model.
Or use an SQL statement:


Alter database name set recovery simple