Maintaining Databases (Database Engine)

Maintaining Databases (Database Engine)

SQL Server 2008 R2

After a database has been created and all objects and data have been added and are being used, there will be times when you have to perform maintenance. For example, it is important that you back up the database regularly.

Topic

Description

Maintenance Plan Wizard

Describes how to use the Maintenance Plan Wizard to help you set up the core maintenance tasks required to make sure that your database performs well, is regularly backed up in case of system failure, and is checked for inconsistencies.

Maintenance Plans

Describes how to use maintenance plans to create a workflow of maintenance tasks.

Community Additions

ADD
Show:
© 2016 Microsoft