Database Maintenance

Database Maintenance

Database Maintenance

It is recommended that the HelpMaster database is regularly maintained by a qualified, SQL Server administrator. Best practice procedures include regular backup, data integrity checking, query optimization and indexing.  When the HelpMaster database is created, a maintenance plan is not created with it.  This will need to be implemented by your database administrator.

For further information about database maintenance, please consult SQL Server Books Online.  A search on “Database maintenance” or “maintenance plans” will prove helpful.

Additional SQL Server resources are available from Microsoft at

See Also

Why is database maintenance important?

A regularly maintained database will perform better, occupy less space on your server hard-drive, and have less internal errors and inconsistencies.  In the event of catastrophic hardware failure, database crashes, or system malfunctions etc, having a recent database backup is essential.


Below is a simplified example of a maintenance plan that might be appropriate for your environment.  It is highly recommended that you perform you own research to determine which database maintenance plan is suitable for your environment.

  1. From SQL Server Management Studio, expand Management, right-click on Maintenance Plans and select **New Maintenance Plan...

  2. Give the plan a name!

  3. From the Toolbox, drag and drop maintenance tasks onto the subplan to build up your plan.  For a detailed discussion on each of the maintenance tasks and the suggested order in which they should be arranged, please refer to the Microsoft SQL Server documentation.

  4. Right-click on the task and select Edit... to configure the task to your requirements.

  5. Connect each task to each other by dragging the arrows onto the next task to be executed

See Also

Database and Reports Wizard

Database growth

Hardware and Software Requirements - Microsoft SQL Server