Overview
M-Files vaults that use MS SQL as the vault's database engine supports storing filedata on MS SQL or in the Windows file system. For production use vaults, it is best to store filedata in the file system on disk instead of inside MS SQL database. This is due to the overhead imposed by heavy data I/O to the SQL server if it were utilized as the storage of the filedata in SQL. In order to avoid a performance cost, it is recommended to store filedata on the file disk directly.
Keep in mind that this makes vault backups more complex as the metadata and filedata must be backed up separately in addition to the correct order. Please refer to our backup policy in our knowledgebase for more information: https://kb.cloudvault.m-files.com/Default.aspx?#3ECA226F-7B54-428B-B539-DE443E6134EC/object/12DBD11C-9FF8-4839-9DE5-6F6277A48A1A/latest
