DATABASE MANAGEMENT

Database maintenance
To keep a specific database in good working order, perform these tasks regularly.
TaskFrequency
Monitor replication, if a database replicates Daily
Check for and consolidate replication or save conflictsDaily, for large active databases; weekly for other databases
Monitor database activity Weekly
Monitor database sizeWeekly
In addition, if you're a server administrator, perform the following tasks regularly to maintain all databases on a server.
TaskFrequency
Run the Updall task to update all views and full-text indexesDaily. Occurs by default daily at 2 AM.
Run the Designer task to keep databases that inherit design from master templates in sync with the master templatesDaily. Occurs by default daily at 1 AM.
Run the Compact task Weekly or monthly with the -B argument and in conjunction with a certified backup utility.
Monitor the database cacheOccasionally
See also