Database full


We are running an on-premise instance of JitBit Helpdesk using SQL Express. We have hit our 10GB database size limit, but do not have the budget to upgrade to SQL Standard. Is there a way of purging all tickets before a certain date from the database?


Consider enabling the ""Auto-delete closed tickets after (days)" setting introduced in the recent versions.

If you are running an older version of the software, you can try "shrinking" the database and the transaction log file in SQL Management Studio, this should free up some space. There are many tutorials out there on how to do that.

Other than that, consider deleting the old tickets and especially large file attachments from the tickets. You can do that by hand using the grid (for tickets) and the ticket page (for attachments).

And you would still need to "shrink" the database after deleting the tickets.
Creation date: 2/26/2019 6:12 AM (Vlad)      Updated: 4/20/2022 7:20 AM (Alex)
Jitbit Helpdesk ticketing system is our flagship product. Its a great helpdesk software app offered both as a hosted and "on-premise" versions.