Preventing database damage
File corruption is not inevitable, but it's a good idea to take measures to prevent damage and to ensure that databases are properly backed up.
  •
Routine backups are imperative with any database.
  •
Back up heavily used databases frequently enough so that you will not lose more than one day of work.
  •
Use an uninterruptible power supply (UPS).
  •
Check the condition of the hard disk with a drive utility program.
  •
Be sure software that optimizes, compresses, or partitions the hard disk is current.
  •
Be sure driver software is compatible with the operating system version.
  •
Use virus detection software. However, do not run virus protection software on open or hosted databases. First, close the databases, and then run the virus protection software.
Was this topic helpful? Send feedback.