Question:
We are currently using an on-premises instance of JitBit Helpdesk with SQL Express, and we've reached the 10GB limit for our database size. Unfortunately, we do not have the budget to upgrade to SQL Standard. Is there a method for purging all tickets that are older than a certain date from the database?
One option you may want to consider is enabling the "Auto-delete closed tickets after (days)" setting, which was introduced in recent versions of the software. This feature can help manage your database size over time by automatically removing closed tickets that are older than the specified number of days.
Additionally, you might periodically want to "shrink" your database and the transaction log file using SQL Management Studio. This action can help free up space in your database. While there are many tutorials available online to guide you through the process, here's a brief overview:
1. Open SQL Management Studio and connect to your database.
2. In the Object Explorer on the left, right-click on your database.
3. Navigate to "Tasks," and then select "Shrink."
4. Choose "Database" or "Files" based on your requirements.
By regularly maintaining your database in this manner, you should be able to manage your space more effectively without the need for an upgrade.