:::: MENU ::::

Check for any open transaction in transaction log

  • Mar 06 / 2009
  • 0
DBCC Commands, dbDigger, Monitoring and Analysis, Transaction log files

Check for any open transaction in transaction log

There may exist an open transaction within the transaction log. In that case if the BACKUP LOG statement is used, only the inactive part of the log can be truncated. An open transaction can prevent the log from truncating completely. To identify that open transaction use DBCC OPENTRAN in a database.
It will provide the transaction information if there is such present. If no such open transaction exists then an informative message will be displayed.

Consult us to explore the Databases. Contact us