FileBound Database Maintenance plans
We do recommend that you routinely maintain your database. Below are a few guidelines, but keep in mind that every business is unique and your infrastructure should be evaluated by a database professional to ensure your server settings are tailored to fit your companies specific needs.
- Reorganize data and index pages on a regular basis. Leave Change free space percentage to 10%.
- Select Check database integrity and select attempt to repair any minor problems. This should be run on a regular basis.
- Be sure to backup your database regularly. There are many third party software applications that will automate this for you i.e. BackupExec. We generally recommend a full backup nightly. If you need point-in-time recovery, keep in mind that you will need to run SQL in full recovery mode and execute transaction log backups (hourly transaction log backups with full daily backups is common). Running SQL this way will typically increase the database size on disk by around 5%. This is generally only recommended if there are frequent changes to the site with high-volume scanning where losing a day of work is costly.
- We typically suggest rebuilding indexes on the database once you have exceeded a page count of 10 and a fragmentation level of 30%. Weekly rebuilds are generally sufficient though extremely high file/document throughput or high volume workflow may warrant more frequent (nightly/bi-weekly) index rebuilds.
- If the database is in full recovery mode, ensure that transaction log backups are run regularly, if you do not, the transaction log will grow uncontrollably causing you to run out of hard disk space and reduce performance.
- Run backups on a schedule that you’re comfortable with recovery. If nightly backups are sufficient (you’re willing to accept 24 hours of lost work) set the databases to simple recovery mode and don’t worry about transaction log backups, and run the backups nightly.
- Check Database integrity on same schedule as your full backup.
- Rebuild Files, Documents, and DocumentRoute table indexes nightly (if you’re importing large amounts of metadata, images, or workflow)
- Rebuild all Indexes weekly. This re-constructs corrupt or missing indexes in place on the server. A corrupt index can cause unexpected search results, either in the form of an error or returning more or fewer matches than it should.
- Update Statistics regularly. Weekly should be sufficient. If you have a high amount of through-put of files or documents, then nightly might be best, at least on those specific tables (dbo.files and dbo.documents).
Related Articles
FileBound 8.3 Release Schedule
Update 10 January 2025: The deploy to the US Wave1 sites that was scheduled for 12 January 2025 has been delayed. FileBound 8.3 Release December 15, 2024: Partner & Cloud Test Sites December 16, 2024: Central Installation/On-Premise Release FileBound ...
Known Licensing Issue in 8.0.1
Known Licensing Issue in 8.0.1 versions of FileBound If you have purchased Records Management and are reapplying your FileBound license, Records Management will show as not enabled. We will need to contact FileBound Support to generate a code and ...
FileBound - 8.2.0 Release
Release Schedule January 7, 2024: Partner & Cloud Test Sites January 8, 2024: Central Installation/On-Premise Release February 2, 2024: Wave US-1 Cloud Sites March 6, 2024: Wave UK Cloud Sites March 10th, 2024: Wave US-2 Cloud Sites Release Notes for ...
Docusign legacy authentication ends Sept 30 2024
Docusign legacy authentication and technical support ends in September 2024 Please review the following information if you are using Docusign's integration with FileBound. In 2021, Docusign began the end-of-life process for all API authentication ...
eForms Basic Setup
eForms Basic Setup You will need project admin rights at the least to access the forms builder. Forms Dashboard Select the project and click on the configuration drop-down at the top. Forms is the 3rd from the top. When you click on Forms you’ll be ...