O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

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

Administering Databases and Applications

Administering a multiuser database involves a number of duties besides adding and maintaining user accounts. A database administrator's most important duty is to ensure that periodic valid backup copies are made of database and system files. The database administrator's other responsibilities consist of routine database maintenance, periodic compacting of database files, and repairing databases.

Backing Up and Restoring Databases

The following maxims relate to maintaining backup copies of database files:

  • The time interval between successive backups of databases is equal to the amount of data you are willing and able to re-enter in the event of a fixed-disk failure. Except in unusual circumstances, such ...

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