Review M-Files on G2 & get a $25 gift card Arrow right Review us!

Options
  • State Verified Answer
  • Locked Locked
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 15 subscribers
  • Views 512 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

Optimize Database (Thorough) - SQL

Uros Sankovic

Hi,

Is there a way to optimize a database and delete the destroyed documents from the disk and not run the optimization manually?  I know so far that was not possible, but still... Is there a way to automate the SQL database optimization which will also delete destroyed documents from the disk?

Best, Uros

Parents
  • +1

    From what I have learned it is necessary to run Verify & Repair Thorough to release disk space from destroyed objects. This will take the database offline. I would advise against automation unless you are absolutely certain that you have a service window available at regular intervals to do so. And I am not sure that can be done at all unless you can find a way run a scheduled activity in Windows and use the API to start the process. I have only found the VerifyVault method in documentation, and I don't think it will do a thorough repair.

  • 0 in reply to bright-ideas.dk
    bright-ideas.dk said:
    From what I have learned it is necessary to run Verify & Repair Thorough to release disk space from destroyed objects.

    I didn't know that, so thank you for that info. Maybe the best thing is to run both jobs, just to be sure Slight smile

    THX again.

    Best, Uros

Reply Children
No Data
M-Files
M-Files Support


© 2024 M-Files, All Rights Reserved.