Reduce log file size in SQL

SQLreduce the log file size

Author : CC Abba

2014-6-14

in Daily SQL database operations, there are often SQL log files are oversized and larger than normal MDF database files, as a general user, LDF is too large, it only affects the server's hard disk space. Here's a quick way to reduce the number of log documents to more than Kin seconds.

But I remind you, for the sake of insurance, please back up the database before the operation, in order to avoid data loss. It is also A good practice for IT staff.

DUMP TRANSACTION Filecenter with no_log

BACKUP LOG Filecenter with no_log

DBCC Shrinkdatabase (Filecenter)

--backup LOG HZEW2 with TRUNCATE_ONLY

--DBCC shrinkdatabase (' HZEW2 ')

For more technology sharing, you can join our technology group.

Welcome to join the technology sharing group: 238916811

Reduce log file size in SQL