Retour
-
Titre
Can the InTrust Alerts Database be deleted to clear old alerts? -
Description
Would like to clear real-time alerting db. Can the InTrust Alerts Database be deleted as the Alert Database cleanup job is not removing old alerts. -
Cause
The InTrust Alert Database is used to keep current alerts from enabled Real-Time Monitoring rules and typically should only reatain a weeks worth of data. To avoid alert database overgrowth, it is recommended that you periodically run a database cleanup job. -
Résolution
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.