How to narrow down huge transaction log files in MSSQL

Large database log files occupy a large amount of disk space. If the file is not processed in time, the database cannot be started. The following describes how to truncate Database Transaction logs.

1. Open the SQL Server Query Analyzer

2. Enter the following command:

Backup log databasename with no_log

Databasename is the name of the database to be truncated.

Press F5 to execute

3. shrink the database in the Enterprise Manager.

The log size is about K-1 m after the contraction is completed.

Original from [origin interconnection], reproduced Please retain: Origin Interconnection: http://www.hnyuandian.com