Scenario:
Available disk space is getting dangerously low towards the end of each month or runs out completely and reaches 0MB of free space before the end of each month causing data gaps in reports.
Note that the Advanced Reporting ETL job is designed to automatically purge file groups that are older than the retention period. The ETL does this within the first few days of each month.
Question:
What can we do to avoid data gaps in reports and bring free disk space back to safe levels?
Answers:
1. The safest and supported way is to reduce the retention period by re-running the deployment script setup.bat pointing it the existing database, selecting 'U' option (Use existing database), then entering a smaller number of months of retention and then relying on the ETL to remove old file groups/partitions automatically at the first few days of the month. See this post for running the setup script to change retention:
https://community.ir.com/t5/Unified-Communications/In-Advanced-Reporting-can-I-change-how-many-month...
2. Alternatively (Requires SQL knowledge) move file group files to another drive (take the database off line, move files, alter database file filenames to the new path, bring database online).
* Make sure there is a complete full backup of the database before attempting this.
HTH
