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 use an SA connection for running these options.
You should also update the database statistics as needed.