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

Get Special Edition Using Access 97, Second Edition 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.