Options
  • State Verified Answer
  • Locked Locked
  • Replies 2 replies
  • Subscribers 13 subscribers
  • Views 1415 views
  • Users 0 members are here
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Result of change file data location

keletis

Dear All,

We have a large vault with a lot of files (~150Gb) which we store in SQL database.

We would like to change the location of file data from SQL to file-system folder.

My question is where will the result of this changing?

According to the userguide's information, if we are changing the vault file data location from the vault database to the file system, the file data of the vault is then copied to the new location.

Is it meaning that, the earlier created, already existed files will removed from the SQL databased or not?

Could we reduce the size of the SQL database any way?

Thanks any advice in advance

Parents
  • +1

    You probably have to use the Optimize Database (Thorough) afterwards to reduce the size of the SQL database. This will take the vault offline for the duration of the process. I have not tried to move files out of SQL (never put them there in the first place). You should test this on a smaller vault before setting in motion.

Reply
  • +1

    You probably have to use the Optimize Database (Thorough) afterwards to reduce the size of the SQL database. This will take the vault offline for the duration of the process. I have not tried to move files out of SQL (never put them there in the first place). You should test this on a smaller vault before setting in motion.

Children
No Data
M-Files
M-Files Support


© 2025 M-Files, All Rights Reserved.