SQL Server log file Growth reason location

Method 1, sys.databases;

--------------------------------------------------------------------------------------------------------------- -------------------------------------------

Log file Growth reason:

1, the database recovery is not simple, but for a long time no backup.

2. There is a transaction in the database that has not been committed for a long time.

3, the database has a large transaction is running.

4. There is a problem with database mirroring.

5. There is a problem with database replication.

Method 1,

By sys.databases the reasons for the problem.

Select Db_name (db.database_id) as Nbname, Db.log_reuse_wait_desc
From sys.databases DB

1. Nothing has multiple reusable log files.

2. Checkpoint has not been checkpoint since the last log truncation.

3, log_backup to show log backup.

4. Backup or restore of the Active_backup_or_restore database is in progress.

5, active_transaction transaction is active.

6, database_mirroring database in the mirror.

7. The replication transaction is in the process of copying.

8. The Database_snapshot_creation database is creating a snapshot.

9, Log_scan is logging scanning.

SQL Server log file Growth reason location