The InTrust Alert database stores alert records provided by InTrust monitoring with a retention of typically one week. However if the cleanup job has not completely cleaned out old alerts and the desire is to flush the database completely, then the database can be deleted and re-created.
The Default InTrust Alerts Database is easily recreated.
1) Stop the InTrust Real-Time Monitoring Server service.
2) Delete (or disconnect and move some place else) the Default InTrust Alerts DB from SQL Studio.
3)Once dropped go back to InTrust Manager under Configuration | Data Stores | Databases |.
4) Select the properties on "Default InTrust Alerts Database...".
5) Then "Manage Database" tab and finally click the "..." button to launch db wizard.
6) Click "Next" x3. Click "Finish"
7) Restart the "Quest InTrust Real-time Monitoring" service.
This will recreate table structures,etc in the InTrust Alert DB.