Friday, April 17, 2015

Reasons for Backing Up a Database

List reasons for backing up a database. List some ways to back up a database.

Backing up a database is an important step to protect the the data. from loss. Databases should be back up a database on a regular basis:

  1. before modifying or deleting data.
  2. before performing any maintenance operations on the database.
  3. after adding data to the database.
Ways to back up database:
  • If the computer already has a back up program running, it might be backing up your database. Check your backups to determine whether the database is included in the back up. If not, configure the backup program to backup the database.
  • Copy the database to another storage device.
  • Copy the database to different folder on the same storage medium as the original database. This method is effective for keeping multiple copies in an accessible location, but you will lose both the original database and the back ups if the storage device fails. 


No comments: