How to change the Intrust Cleanup job to clear all data and transaction logs.
Perform the following
1. Open SQL Enterprise Manager and expand your database and select the Stored Procedures option.
2. Open the sp_EventAdminClearDatabase stored procedure
3. You need to uncomment (remove the --) in the sp_EventAdminClearDatabase
TRUNCATE TABLE [dbo].[GatheredEvents]
4. Add the following entries after this entry
dbcc shrinkfile ([db_name()])
backup log tempdb with truncate_only
backup log [db_name()] with truncate_only