How to resolve "Transaction log is full" error while deleting Projects

 Product(s):Promis.e, Bentley Substation
 Area:Database Platform Support

Error or Warning Message

When attempting to delete a very large project, an error message is displayed indicating that the transaction log is full.


Each SQL Server database has a corresponding transaction log. When created by the default SQLServerProject.sql script, the transaction log file of the SQL project database is set to automatically grow as needed, up to some maximum size.  In one case, this size was insufficient for the amount of transactions taking place during the deletion of the large project.

How to Avoid

Increase the maximum size of the transaction log file.

Option 1 - Using the SQL Server Management Studio interface

  1. In Object Explorer, expand "Databases".

  2. Right click the name of the project database and select Properties.

  3. Go into the Files category and click the [...] button for the log file in the "Autogrowth" column.  The log file is probably named after the project database with a "_log" appended to the end of the file name.

  4. Increase the value for Restricted Growth, perhaps start by doubling it. 

Option 2 - Using a script

The following script, modified with the true database and log file name and desired log file size, could also be executed using SQL Server Management Studio or other means:

(NAME = myDB_log,
SIZE = 500MB);

 Original Author:Avanti_K