Documentation Center

Purging finished publish transactions

When a publish action is finished, SDL Tridion keeps a record of it in the form of a finished publish transaction. If many publish actions are frequently performed, these publish transactions can fill up your Content Manager database. To prevent this, purge the finished publish transactions.

Before you begin

To purge these publish transactions, you must have the DLL for purging loaded in Windows PowerShell.

Procedure

From the PowerShell command prompt, enter the command Remove-TcmPublishTransactions, applying the following parameters:
Successful
Specify this parameter to purge successful publish transactions.
Failed
Specify this parameter to purge failed publish transactions.
Before
An optional timestamp (DateTime) indicating the cutoff point after which no publish transactions should be purged. For example, set this parameter to 17 January 2013 to keep all publish transactions created after that date.
SDL Tridion purges the publish transactions that meet the criteria you specified and to which you have access: either the publish transactions you initiated yourself or, if you are logged in as a system administrator user, all publish transactions that meet the criteria you specified. The return value is the number of publish transactions that were purged.