You are currently reviewing an older revision of this page.
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.
Increase the maximum size of the transaction log file.
In Object Explorer, expand "Databases".
Right click the name of the project database and select Properties.
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.
Increase the value for Restricted Growth, perhaps start by doubling it.
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:ALTER DATABASE myDBMODIFY FILE(NAME = myDB_log,SIZE = 500MB);