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.