In Tools\System Utilities\Admin Utilities there is a feature called, "DB Health Audit", what is that and how I can use it?
The Database Health Audit is for self-hosted customers to assist with managing your data. The tool will show you when your last FIMS database back up was and will show you information regarding your database structure.
1. When you first launch the DB Health Audit, you will see an informational message that will tell you when your last database backup was taken. This message is generated from the latest file date in npo\found\dbbackup on your FIMS server. What this means is that this is the last time an actual FIMS database backup was done. You may have a process in place to backup your database files or the entire server, but this message is specific to the actual database backup process itself which is not the same as making a copy of the database files or the NPO directory. It is recommended that you create regular database backups so that in case of emergency you can restore to a recent data backup if needed:
2. After you click OK on the message regarding the database backup you may see a message regarding the database buffer:
This is an informational message about the current state of your database files. When you click on the message above, you will see a report as shown below. This report shows any database areas that have increased beyond the allotted indexed file space.
If you do not see any message as shown above, or a report below, then that means that the DB Health Audit Utility did not identify any database files needing to be restructured. If you do see areas in your database listed in the DB Health Audit report that need to be restructured, Blackbaud Professional Services can complete this work for a fee. Please contact customer support and provide them a copy of your DB Health Audit report and the analyst will send your request on to our Services team who will connect with you on re-structuring your database.