Skip to main content
Tridion

Return to Question

Tweeted twitter.com/#!/StackTridion/status/342654840620589056
edited tags
Link
Rob Stevenson-Leggett
Rob Stevenson-Leggett
  • 7.3k
  • 3
  • 23
  • 49
added 21 characters in body
Source Link
Will Price
Will Price
  • 16.4k
  • 1
  • 21
  • 61

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.

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:

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.

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.

Source Link
Will Price
Will Price
  • 16.4k
  • 1
  • 21
  • 61

Cannot delete publication error: The transaction log for database 'tridion_cm' is full

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:

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.