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 I see the text `NOTHING`, which doesnt seem particularly enlightening. 

I also found and ran the following SQL to check files for the DB:
<!-- language: lang-sql -->

    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.