Deleting Request does not remove the attachment

Hi

I have a number of requests with attachments that I do not need any more.

If I delete the request it does not remove the attachment which means my database and backup are just getting bigger and bigger.

Having asked about tidying up the database after deletions I was given this:-

c:\Adventnet\Me\servicedesk\Mysql\Bin>mysql.exe -u root -P 33366 servicedesk
Mysql> delete from aaaaccsession;
Mysql> delete from auditrecord;
Mysql> delete from recentitems;
Mysql> delete from errorlog;

When we delete entries from above tables, the below tables will get deleted by foreign key constraint.

* aaaaccsession
o aaaacchttpsession
o aaaaccsessionaudit
* auditrecord
o operationauditrecord

Please use the above for MYSQL, if you are using MSSQL you directly use the query editor and run the queries.

whilst it did some stuff, the attachments are still in the attachments folder - mixed in with ones I want to keep. Is there a way round this?

If I delete an attachment just by deleting the file from the folder, but leave the request intact, does it mess up the database?

Thanks for any advice.

Bin