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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.