Shrink my FogBugz database by removing old email attachments?
We have been using the full version of MS SQL Server Standard for our FogBugz 7.0 installation, but are now downgrading to MS SQL Server Express. However, SQL Server Express has a 4GB database limit and our database is over 6GB in size mostly due to many large file attachments from email.
How do I remove all file attachments over a certain size or older than a certain time period? I would like to maintain the text from the cases themselves for reference, but do not need the attachments.