Database log file shrinking

The database used by the project is backed up by the original, resulting in a large log file, taking up a lot of space, searching the internet for information on the shrinking of the log, sorted down.

--Empty log

DUMP TRANSACTION ewaboqdb with no_log

--Truncate the transaction log

BACKUP LOG ewaboqdb with no_log

--Shrink Log

Right-click the database to shrink--task--shrink--FILE--file type selection log--shrink mode Select shrink to XXM input OK

The size of the log file has been reduced by the shrinking of the above completed log file

The following is a limitation on the growth rules for log files

Right-click the database you want to set--Properties--FILE--the auto-grow bar in the log is selected to grow by MB, Maximum unlimited