How to set the database compatibility for a Vault Database.

Autodesk Support

Oct 18, 2023

Products and versions covered

Issue:

Performance problems can be avoided by ensuring the compatibility value for each AUTODESKVAULT User database is set correctly. You would like to know how to do that.

Environment:

This article applies before the 2023.1 Update and later. After that, the Compatibility Level is set to 2016.

Solution:

Download and install Microsoft SQL Server Management Studio (SMSS).

Once SMSS is installed:

Start SMSS.
Windows Start > Microsoft SQL Server Tools 201x > Microsoft SQL Server Management Studio.
Login to the AUTODESKVAULT SQL instance the 'sa' user (or as a user with equal rights as the 'sa' account.)
Expand 'Databases'.
On each User database, right click and select 'Properties'.

Select the 'Options' page and set the 'Compatibility level' to 'SQL Server 2012 (110)'.

Repeat step 5 and 6 for each User Database in the AUTODESKVAULT SQL instance

Note:
Autodesk also recommends the SQL Maintenance Plan is run regularly.

Products:

Vault Basic; Vault Professional; Vault Workgroup;

Was this information helpful?

Need help? Ask the Autodesk Assistant!

The Assistant can help you find answers or contact an agent.

Ask the Assistant

What level of support do you have?

Different subscription plans provide distinct categories of support. Find out the level of support for your plan.