Interviewer - Server > Administration and maintenance > Databases > Maintaining databases
 
Maintaining databases
You should carry out regular maintenance of your databases to make sure that they continue to perform well and can be recovered in the event of a system failure. The maintenance tasks that should be performed regularly include the following:
Check the integrity of a database to make sure that data has not been corrupted by a system error.
Reorganize or rebuilding index to improve performance. This is particularly important for projects that are running large numbers of interviews.
Release unused disk space.
Back up a database.
In Microsoft SQL Server, you can set up maintenance tasks that will execute automatically according to a schedule that you define. The easiest way to do this is to use the Maintenance Plan Wizard.
This section includes step-by-step instructions for using the wizards to reorganize the indexes of your project databases. You can adapt the instructions to run other maintenance tasks as well. For more information about the wizards or maintenance tasks in general, see the SQL Server Books Online documentation.
Example maintenance plan
This is an example of a maintenance plan.
Note When your maintenance plan is in place, ensure that you can restore from your database backups.
Weekly full backup
Weekly database compress
Daily differential backup
See
Reorganizing indexes
Deleting or truncating SQL log files
Maintaining the session history table (ApplicationSessionHistory)
See also
Databases