12 Nov 2012

SQL Maintenance Plans For Vault

Maintenance Plans can be used to schedule tasks required to make sure that the database performs well, such as keeping database and transaction log file sizes small and checking the database for inconsistencies. Autodesk recommends that the plan be run at least once per week, during out of office hours.

In a Connected Workgroup Environment, this should be configured on each SQL Server.

Part of the Administrators tasks should be to regularly check that the plan ran successfully.

If the plan was configured for an earlier release of Vault Server, ensure that you check and update the plan in accordance with this article.

The following steps are universal across all versions of SQL in use with Vault Server (Express and Full SQL). The complete list of supported database engines is located in the product readme file.

Create a SQL Maintenance Plan for Full SQL

Create a Maintenance Script for Microsoft SQL Express

No comments:

Post a Comment