Overview
For FogBugz On-Premise the responsibility of hosting the FogBugz Database and maintaining it is the customer's responsibility, and as such is out of FogBugz's scope of support.
In this article, we gathered a few useful links from the external knowledge bases that could help to execute the most often needed database maintenance tasks.
Introduction
While hosting and maintaining FogBugz Database it is important to be aware of:
- the importance of regular backups
- the impact of the different recovery models and transaction log settings (storage size vs restore possibilities)
- the impact of shrinking log transactions (truncated logs reduce restore in time possibilities)
- the impact of not rebuilding indexes regularly (performance degradation over time)
Description
Microsoft SQL Server KB articles
Please find below external knowledge base article links for a few of the most often met Microsoft SQL Database maintenance tasks:
- Create a Full Database Backup
- Recovery Models (SQL Server)
- Restore and Recovery Overview (SQL Server)
- Shrink the Transaction Log File? aka Managing the Size of the Transaction Log File
- Resolve index fragmentation by reorganizing or rebuilding indexes
- Use the Maintenance Plan Wizard to schedule regular maintenance tasks, like rebuilding indexes
- Server-Level Roles
- Database-Level Roles
MySQL KB articles
Please find below external knowledge base article links for a few of the most often met MySQL Database maintenance tasks:
- MySQL Database Backup Methods
- Export MySQL data with phpMyAdmin
- 10 Ways to Automatically & Manually Backup MySQL Database