Maintenance

After a database has been created and all objects and data have been added and are in use, there will be times when maintenance must be performed. For example, it is important to back up the database regularly. You may also need to create some new indexes to improve performance. These issues should be taken into consideration when designing the database to minimize the effect on users, time taken to perform the task, and effort involved. Maintenance design guidelines include:

Microsoft® SQL Server™ provides the Database Maintenance Plan Wizard for automating many of these tasks, thereby reducing or removing the work involved in database maintenance.

See Also

Database Maintenance Plan Wizard

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.