Versions Compared

Old Version 1

changes.mady.by.user Unknown User (6092b4ded35380006886a5ee)

Saved on

compared with

New Version 2

changes.mady.by.user Unknown User (6092b4ded35380006886a5ee)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Only the inactive portion of the log is ever removed. The inactive portion of the log is the portion of the log up to but not including the start date/time of the oldest open transaction. No matter which method is used to truncate the log, if there is a perpetually open transaction then the log continues to grow in size until it consumes all available disk space.

Reduce the percentage of the log used

If your transaction log size continues to grow despite issuing BACKUP LOG or CHECKPOINT statements, check for a rogue transaction. Begin your research by sorting the Last Batch column on the SQL Processes grid into ascending mode such that the processes containing the oldest batches appear first. Scroll down the list until you find the first user process with a non-zero number of transactions in its Trans column, and then kill this process. Once this is done, perform a CHECKPOINT or BACKUP LOG to reduce the Log File Used Size.

...