How to change the Intrust Cleanup job to clear all data and transaction logs? (21675)

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

How to change the Intrust Cleanup job to clear all data and transaction logs?
Description

How to change the Intrust Cleanup job to clear all data and transaction logs.
Resolution

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

Feedback submitted.

Was this article helpful?

[Select Rating]

Title