Dealing With a SQL Server Database That Has Run Out of Free Space
The Remote Desktop Commander Suite has the capability to collect a massive amount of data over time. Therefore, it is important that you stay on top of your database retention settings in order to make sure that old data is removed nightly to create free space for new data being collected during the current day.
To adjust Database Retention settings, open up the Remote Desktop Commander Configuration Tool, select Application Settings, and then select the Database tab.
In this tab, lower the retention settings for session data and agent data. By default, retention settings are 60 days for session data and 3 days for agent data. So you could lower session data to 30 days and agent data to 2 days or 1 days, for instance.
Once these changes are made, click Save Changes. At the next database maintenance interval, which by default is every night at midnight, the Remote Desktop Reporter Service will purge out old records according to your new retention settings, which should free up space. If you want to clean out space immediately, change the maintenance time from midnight to a few minutes ahead of the current system time, and click Save Changes. This will start the maintenance process soon thereafter. Once the database free space is reclaimed, change the maintenance time back to midnight and click Save Changes again.
Tip 1: If you are running Microsoft SQL Server Express and are continually running out of free space, consider migrating our software to use a full version of SQL Server Standard OR consider using Microsoft Azure SQL on a monthly subscription basis.
Tip 2: You can also control how much data is generated by adjusting the software’s master and agent polling intervals. If you are using our agent service, you can reduce the rate of agent polling to reduce data generation by 50% to 75%. Please read this KB article to learn more about how to do this.
