Thu May 24 14:05:39 GMT 2018
Steps for recovering disk space in Report Manager
- Create a Maintenance Plan (Report Manager install guide) and allow it to execute.
- Adjust Data Retention Period by the smallest increment (Report Manager Online Help), Save, and allow a 2-3 nightly Maintenance runs. See below for details.
- Continue adjusting the Retention by small increments and allowing nightly maintenance as desired.
- If space is not recovered, try shrinking transaction logs as described below.
- If there is still any issue, please contact support and be prepared to move the database temporarily to a larger drive if needed.
Adjust Data Retention settings
- if you see that the database files have grown larger than you expect this may be caused by your data retention settings
- Open Report Manager Administration Console
- Select System Setup and Logs
- Select Data Retention settings
- Here you change your settings to determine how long report manager will keep data for
- Delete unused ODS data:
- Deleting unused ODS data will truncate data tables not used in stock reporting in order to conserve disk space.
- The only reason not to delete this data is you are running custom reports the depend on the data in this database however we highly recommend not building any reports that depend on this database as it is not static and may be dropped in the future.
- If you decide to change your retention settings it is recommended to stagger the time so if you have it set to 2 years first set to 18 months then let it sit for 48 hours then change it to 14 months wait 48 hours then 12 months.
- The reason to do this is because when it begins removing data it delete rows in the database which will cause the transaction logs to grow by staggering it you will reduce the growth on the logs and the potential for the drive to fill up which will undo all the work.
Shrink the Database log files
- Stop the Report Manager services via services.msc, and start task manager. Check that 'dtexec.exe' is not running. If it is, this means that ETL is running and you will need to wait, possibly a few hours.
- Check the location of the database log files - Ex: D:\SQLLogs\
- Identify the log that is grown too large Ex: the warehouse_log.ldf is above 5 gb.
- Check to ensure the recovery mode is set to simple. This will allow for the database to shrink during maintenance without the requirement of a backup, this is needed as the ETL's will likely run much more frequently than a backup.
- You can attempt to shrink the log by going into SQL Management Studio right click the database and select Tasks > Shrink > Files
- Ensure you select file type : log
- Click ok and sql should attempt to released all unused space.
- Restart the Report Manager services.