Overview
In some situations, the hardware limits – or, disk setup may cause SQL Server data storage to find it’s limits in size. There are ways to expand the data storage in the SQL Server.
This is randomly asked from M-Files Customer support, but this matter is scoped out of support personnel to handle. This is a basic instruction about this, and we recommend that a suitable IT Admin instance checks the work until it’s to be put in action.
Solutions
Before doing anything else, make sure your M-Files backups of metadata and also of the filedata locations are in good shape and that they can be restored.
First option:
SQL Server can have more than one data files in different location configured, so adding new datafiles and creating a new data group of those datafiles should solve the issue. For this option, you will need to gather specific information from the Internet of how to do this.
Second option:
Create a whole new disk and move the database to that drive:
1. Take the document vault to offline state
2. Take the database to offline state in MS SQL Management Studio
3. In database properties, check and mark up the location of the datafile location
4. Detach the database from the SQL Server with SQL Server Management Studio
5. Copy the datafile and other files to a new location
6. Attach the database to the SQL Server
7. take the document vault to Online state
Please note that the document vault does not need to be detached in M-Files Admin. Taking it offline as instructed is sufficient.
