Database Maintenance

Most companies store mission-critical information on their SQL Servers. If your data is important to you, it is imperative that you properly maintain your databases. Database maintenance generally includes backing up your database and auditing database access. It is also important that you understand how to restore a database in the case of a failure.

Backing Up Your Databases

Think of backing up your database like brushing your teeth. It is something that you don't think about; you just do it unequivocally each and every day, without exception! Four types of backups are available:

  • Full database backups— Back up the entire database and portions of the log.

  • Differential database backups— Back up data modified since the last ...

Get Alison Balter's Mastering Access 2002 Enterprise Development now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.