SQL Server Log File cleanup

When I restored the database from the database backup, I found that there were more than 120 GB of log files, but I couldn't use SQL Management. I used the DBCC statement to clear it! Space released! And speed!

First of all, we need to check the type of the backup data. This is very important, but it cannot be cleared.

Select name, recovery_model_desc from sys. databases

After the command is executed, you can see the recovery_model_desc category. For the FULL type, you must first change it to the SIMPLE type.

Alter database name set Recovery simple

Start release

Dbcc shrinkfile (n' Database Log File name', 10)

Query after successful release

Select name, size FROM sys. database_files

Change to FULL type

Alter database DNNZhongChangOA SET Recovery FULL