Home
System Administration
This section, intended mainly for M-Files system administrators, explains how to manage, maintain, and configure the M-Files system.
Setting Up and Maintaining M-Files
Managing Document Vaults
Vault Operations
Creating a Vault
Document Vault Advanced Properties
Using Microsoft SQL Server as the Database Engine

Using Microsoft SQL Server as the Database Engine

Instead of Firebird, you can use Microsoft SQL Server as the database engine. We recommend that Microsoft SQL Server is used if the vault contains several hundreds of thousands of objects. With large vaults, Microsoft SQL Server provides better efficiency than Firebird. However, with Microsoft SQL Server, the administrator must be familiar with Microsoft SQL Server management.

With Microsoft SQL Server, the database server memory can be more efficiently used and the backup storage of large data vaults is improved. You can also switch to the mirrored database server without delay if necessary.

Note: Microsoft SQL Server licenses are not included in M-Files licenses. They must be purchased separately.

Migration to Microsoft SQL Server

See Migrating the Vault Database to Microsoft SQL Server.