O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required