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.
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.
Describes how to use maintenance plans to create a workflow of maintenance tasks.