Question

Other than backups, is there any regular maintenance recommended (daily, weekly, monthly) for the FogBugz SQL Server database?

Answer 1

Nothing particular to FogBugz. I think the safe answer is "no".

Some of our customers create lots and lots of data so adjustments to the journal size or periodic defrag of the indices is warranted. I wouldn't worry about it. On the whole, I'd bet most people would spend more time trying to optimize the database than the sum of all the time they'll save. If you think things are getting too slow, contact support and we'll try to help you out. This is a rare enough occurrence, with varied causes, that's it not something to proactively worry about.

(Note: in SQL Server, if your database recovery mode is anything other than simple you'll want to make sure you backup your transaction logs as well, otherwise they will continue to grow and eventually fill up your disk.)