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 www.microsoft.com/sql
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 your own research to determine which database maintenance plan is best suited for your environment.
From SQL Server Management Studio, expand Management, right-click on Maintenance Plans and select New Maintenance Plan...
Give the plan a name
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. http://msdn.microsoft.com/en-us/library/ms140255.aspx
Right-click on the task and select Edit... to configure the task to your requirements.
Connect each task to each other by dragging the arrows onto the next task to be executed