Transaction Log

All SQL Server transactions are logged to the Transaction Log file. The Transaction Log contains an audit trail by default and can grow to be quite large. To conserve disk space consider doing one of the following:

Use a truncated Transaction Log by default.

Use a CIMPLICITY maintenance action truncate the Transaction Log periodically.

Truncate the Log as a System Default

  1. Open the SQL Enterprise Manager in the Microsoft SQL Manager program group.

  2. From the Manage menu, select Databases. The Manage Databases dialog opens.

  3. In the Manage Databases dialog, double click on the database used by the CIMPLICITY Database Logger. The Edit Database dialog opens.

  4. In the Edit Database dialog, select the Options tab.

  5. Select the Truncate Log on Checkpoint option.

  6. Click OK.

  7. Close the Manage Databases dialog.

Result: The change takes place the next time the SQL Server is restarted.

Truncate the Log as a CIMPLICITY Maintenance Action

  1. Open the Database Logger in the CIMPLICITY program group.

  2. Select a table from the list of tables.

  3. Open the Table Properties dialog for the table.

  4. Select the Maintenance Actions tab.

  5. In the Command Action field, enter:

dump transaction DATABASENAME with no_log

This command will dump the Transaction Log without saving the log.

If you want to save the log to a file, see your SQL Server documentation on how to do this.

  1. Select the Maintenance Events page.

  2. Configure the event that will trigger the action.

This change takes place the next time you update the project's configuration and then restart the project.

It is recommended truncating the log as a system default.

image\ToDo.gif To set truncate the log as a system default:

  1. Open the SQL Enterprise Manager.

  2. Select the database you are logging to.

  3. Right-click on the database.

  4. Select Properties from the popup menu.

  5. Select the Options tab.

  6. Make sure that Truncate Log On Checkpoint is checked.

More information


Database management for SQL Server.