Open topic with navigation

Performing Database Consistency Checks

It is recommended that you perform weekly internal consistency checks of the data and data pages within the database to ensure that a server error has not damaged your database. Your SQL Server Administrator should check the output of the DBCC command for errors and refer online to the SQL Books for procedures on recovery from errors.

To Perform a Database Consistency Check

1. Ensure that no users are logged on to eSite.
2. Perform one of these actions:
• AMSI Recommendation – Use the Database Maintenance Plan Wizard to perform this task.
• Use SQL Query Analyzer (SQL 2000) or SQL Management Studio (SQL 2005) to run the following query on the eSite database: DBCC CheckDB

See Also

System and Database Maintenance

Maintenance Tools and Tasks

Clearing Temp Tables in the EvolutionConfig Database

Clearing the Letters or Output Directory

Deleting Temp Tables in the eSite Database

Re-indexing the eSite Database

Reviewing the Event Log

Backing Up Your Database