SQL Server log file cleanup

When you restore a database from a database backup, you find that the log file actually has more than 120 g, not through the SQL management, resolute use DBCC statement cleanup success! Free space! and clear and speed!

First of all, it's important to look at the type of backup data, or not to clean up

Select Name, Recovery_model_desc from sys.databases

After execution, you can see the category of Recovery_model_desc, and if it is full type, be sure to change it to simple type first.

ALTER DATABASE name set Recovery simple

Start releasing

DBCC shrinkfile (N ' database log file name ', 10)

Query after successful release

SELECT NAME, size from sys.database_files

Change back to full type

ALTER DATABASE Dnnzhongchangoa SET Recovery full