Knowledge Base Article: Database maintenance plan configuration

Database maintenance plan configuration

Database:1

database maintenance performance SQL Server indexes backup statistics

HelpMaster > Database

Database

2/3/2012 12:58:10 PM

8/2/2017 3:10:17 PM

Average Rating (from {{model.ratings}} ratings)
0 Attachments
0 See Also Links

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 www.microsoft.com/sql

See also

http://msdn.microsoft.com/en-us/library/ms187658.aspx

http://www.sql-server-performance.com/articles/dba/Overview_of_Maintenance_Plans_in_SQL_Server_2008_p1.aspx

http://www.sqlskills.com/BLOGS/KIMBERLY/post/Database-Maintenance-Best-Practices-Part-I-e28093-clarifying-ambiguous-recommendations-for-Sharepoint.aspx

http://www.sqlteam.com

 

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.

 

Use

 

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.

 

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

    [image]


  2. Give the plan a name

    [image]


  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.  http://msdn.microsoft.com/en-us/library/ms140255.aspx

    [image]


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

    [image]


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

    [image]