DATABASE MANAGEMENT

Database maintenance
To keep a specific database in good working order, perform these tasks regularly.
TaskFrequency
Monitor replication, if a database replicatesDaily
Check for and consolidate replication or save conflictsDaily, for large active databases; weekly for other databases
Monitor database activityWeekly
Monitor database sizeWeekly
In addition, if you are a server administrator, perform the following tasks regularly to maintain all databases on a server.
TaskFrequency
Run the Indexer task Updall 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 synchronized with the master templatesDaily. Occurs by default daily at 1 AM.
Run the Compact taskWeekly or monthly with the -B argument and in conjunction with a certified backup utility.
Monitor the database cacheOccasionally
Related topics