Advertisement

Maintaining Your Database

  • Robin Dewson

Abstract

At this point, we have now created a backup and performed a restore of the example database. We have also covered the different methods to back up and restore the database. However, we have no real plan for maintenance and detection of problems in our database strategy. Any jobs for backup of the database or transaction log are held as single units of work called steps. Not only that, but there is nothing in place that will look after the data and indexes held within the database to ensure that they are still functioning correctly and that the data is still stored in the optimal fashion.

Keywords

Previous Chapter Maintenance Plan User Database Integrity Check Data Page 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Robin Dewson 2001

Authors and Affiliations

  • Robin Dewson

There are no affiliations available

Personalised recommendations