Maintaining Databases (Database Engine)

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.

In This Section

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.

See Also

Other Resources

Maintaining Databases (Database Engine)
Optimizing Databases
Implementing Databases
Designing Databases
Understanding Databases

Help and Information

Getting SQL Server 2005 Assistance