Clear SQL Server database logs

How to clear database logs

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.

There are two methods to clear logs:

1. Automatic cleanup

The database option trunc log on chkpt is enabled to enable the database system to automatically clear logs at intervals. The advantage of this method is that it is automatically executed by SQL Server without manual intervention, and generally logs are not full. The disadvantage is that only logs are cleared without backup.

2. Manual cleanup

Run "Dump transaction" to clear logs. The following two commands can clear logs:

Dump transaction with truncate_only
Dump transaction with no_log

You can use the "Dump transaction with trancate_only" command to delete the inactive parts of the transaction log. When writing this command into the transaction log, you must perform necessary concurrency checks. Sybase provides "Dump transaction with no_log" to deal with some very pressing situations. Using this command is highly risky. the SQL server displays a warning message. To ensure Database Consistency as much as possible, you should take it as the "last move ".

The above two methods are only ?? Clear logs without backing up logs. To back up logs, run the "Dump transaction database_name to dumpdevice" command.