No you're totally right. That's how I would have preferred it too. I'm impatient and self-destructive.I've deleted all 2014 tickets and kept attachments from October 2015 till present.Instead of truncating the table, I'm sorting by date and deleting those dates prior to the first ticket in october 2015. I don't know the sql query for that, so I'm manually doing it.I must be missing something, because the database size only reduced by 50 mb. 350mb - 302mbI read this in another forum post:http://forum.osticket.com/d/discussion//how-to-remove-attachments"TRUNCATE TABLE ost_file""TRUNCATE TABLE ost_file_chunk""TRUNCATE TABLE ost_attachment" "TRUNCATE TABLE ost_ticket_attachment"