Set Database Maintenance Options for SQL Server - Intergraph Smart Instrumentation - 13.1 - Installation & Upgrade - Intergraph

Intergraph Smart Instrumentation Installation and Upgrade

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Installation & Upgrade
Smart Instrumentation Version
13.1

You set the database maintenance options for SQL Server using the DBCC Utility. It is recommended that you run the following options about once a week:

  • CHECKCATALOG

  • CHECKDB

You must be logged on with the System Administration logon name and password as defined in the Microsoft SQL Server Connection to use or run these options.

You should also update the database statistics as needed.