The below are the root causes to grow the log file .
1. Checkpoint has not occurred since last log truncation.
2. Mirroring is paused or mode is in high performance.
3. Long running active transactions
4. In Replication publisher transactions are not yet delivered to distributor.
5. Huge number of database snapshots is being created.
6. When database is in Full recovery model , no log backups are performed after Full backup.
7. An active Backup / Restore operation is running from long backup.
1. Checkpoint has not occurred since last log truncation.
2. Mirroring is paused or mode is in high performance.
3. Long running active transactions
4. In Replication publisher transactions are not yet delivered to distributor.
5. Huge number of database snapshots is being created.
6. When database is in Full recovery model , no log backups are performed after Full backup.
7. An active Backup / Restore operation is running from long backup.
No comments:
Post a Comment