Evidence data purging is based on reporting database purge settings for historical results. The option Purge historical results from reporting database after N days from the Reports tab, under Purge settings is used for purging of evidence data. The evidence table and filegroup are deleted after the purge period is over. The default retention period for evidence purge is three years (1095 days).
If there are issues with deleting filegroups during purge operations, then evidence data purge is required to be a part of the database maintenance plan. During the normal purge operations, there can be errors because some files are in use. If you identify any orphan filegroups, you can delete them manually.
To delete a filegroup manually
Run the query:
(select PartitionName as TableName,Filegroup from EvidencePartitionInfo where State = 2)
Manually delete the table and filegroup that is returned from the query in step 1. Delete the filegroup and table in one of the following ways:
Navigate to the evidence storage table and right-click and select Delete.
Navigate to CSM_Reports->Properties->Filegroup and click Remove and OK.
Imported Document ID: HOWTO76815
Subscribing will provide email updates when this Article is updated. Login is required.