While trying to delete an old publication, I get the error:
The transaction log for database 'tridion_cm' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases Unable to delete Publication (tcm:0-33-1). A database error occurred while executing Stored Procedure "EDA_PUBLICATIONS_DELETE".EDA_PUBLICATIONS_DELETE
Looking in the log_reuse_wait_desc column for tridion_cm (SQL Server 2008 R2) I see the text
NOTHING, which doesnt seem particularly enlightening.
I also found and ran the following SQL to check files for the DB:
SELECT name AS [File Name] , file_id, physical_name AS [Physical Name], size/128 AS [Total Size in MB],size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0 AS [Available Space In MB] FROM sys.database_files;
This shows the log to have plenty (>180MB) of space.