SQL database management
The following lists best practices when using SQL Server with FortiClient EMS:
- By default, FortiClient EMS is installed with SQL Server Express. However, SQL Server Express has a 10 GB limit. If managing more than 5000 users, it is recommended to use EMS with a licensed version of SQL Server, such as Enterprise or Standard, which support redundancy, backup, and more database entries and storage.
- Perform SQL database backups regularly.
- Practice data redundancy to ensure an instance of the database is available at all times.
- Restore the database and clean up old entries on a regular basis.