When running an Audit Database cleanup, you receive the following error:
"Cannot clean up obsolete data from one or more data stores. ADC Error: Unspecified error (0x8adc1005)"
The rights have not changed and all reports, gathering, and imports are working successfully. Only cleaning the database is failing.
Possible causes:
1. The rights on the database truly have changed.
2. The "tempdb" transaction log size has "overgrown".
If the rights have changed, make sure that the cleanup job is configured to access the target Audit database (default name: "InTrust_Audit_DB") under an account with sufficient rights and that the SQL Server login it uses has the InTrust AuditDB Cleanup role for the database. The rights are created during the InTrust setup or the SQL scripts shipped with the DVD.
After making sure that the rights have been set properly and the error still occurs, follow these steps:
1. Change the recovery mode from "Full" to "Simple":
Click "Start" | "All Programs" | "Microsoft SQL Server" | "Enterprise Manager".
In "Enterprise Manager", click "Console Root" | "Microsoft SQL Servers" | "SQL Server Group" | <SQL Server name> | "Databases" | right click "InTrust_Audit_DB" | left click "Properties" | "Options" | In "Recovery", select the "Model" pull down menu to "Simple" | Click "OK" | exit "Enterprise Manager".
More information about these settings can be found here:
http://support.microsoft.com/kb/873235/en-us
2. In the "dbo.sp_EventAdminDeleteEventsOlderThan" stored procedure, comment out the 2 following lines below and execute the procedure:
The store procedure can be viewed here in Enterprise Manager:
Click "Start" | "All Programs" | "Microsoft SQL Server" | "Enterprise Manager".
In "Enterprise Manager", click "Console Root" | "Microsoft SQL Servers" | "SQL Server Group" | <SQL Server name> | "Databases" | "InTrust_Audit_DB" | "Stored Procedure" | double click "sp_EventAdminDeleteEventsOlderThan".
The store procedure can be viewed and execute here in Query Analyzer:
Click "Start" | "All Programs" | "Microsoft SQL Server" | "Query Analyzer".
In "Query Analyzer", in the left pane, click "InTrust_Audit_DB" | "Stored Procedure | "dbo.sp_EventAdminDeleteEventsOlderThan" | "Edit" | at the top pull down menu, make sure to select "InTrust_Audit_DB".
Now remove the comments (--):
Old:
--------------------------------------
commit tran
--backup log tempdb with truncate_only
--backup log @dbname with truncate_only
truncate table #deletingids
---------------------------------------
New:
--------------------------------------
commit tran
backup log tempdb with truncate_only
backup log @dbname with truncate_only
truncate table #deletingids
---------------------------------------
Next, click the green Execute button.
Close SQL Query Analyzer and click "No" when it asks to save the changes.
MORE INFORMATION can be found in these threads:
http://qlist1.quest.com/read/messages?id=20569
http://qlist1.quest.com/read/messages?id=20576
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center