Alarmingly, I just hit the 2GB limit for HQ Server. I am going to upgrade to SQL Express, but I have not even been using HQ for a year with 4 stores. I can't believe my database is so large already. What happens in companies with dozens of stores? It seems like the HQ database would be over the size limit in a matter of weeks.
How can I quickly and immediately decrease size without losing too much?