You set the database maintenance options for SQL Server using the DBCC Utility. It is recommended that you run the following options after every week. You must use an SA connection for running these options.
-
CHECKCATALOG
-
CHECKDB
You should also update the database statistics as needed.