Destroy Documents

This depends on the database engine that the vault uses:

• With the embedded Firebird database, file data is destroyed from disk when the document is destroyed in the vault
• If the vault is using SQL Server and storing the file data in the file system (instead of the vault database), file data is destroyed from disk only when running manual optimization for the vault database

This depends on the database engine that the vault uses:

• With the embedded Firebird database, file data is destroyed from disk when the document is destroyed in the vault
• If the vault is using SQL Server and storing the file data in the file system (instead of the vault database), file data is destroyed from disk only when running manual optimization for the vault database

Thank you

My files are stored in D drive and the metadata is managed in SQL server so I will have to run the manual optimization. correct? 

Yes, the recommendation mentioned in the user guide is to run it 1-4 times a year.

Thanks Joonas for the help as always. Can I run the optimization while users are logged in? Will this cause an disruption?

Vault will be taken offline for the duration, like it says in the user guide.