Methods For Database Backup And Recovery

Methods For Database Backup And Recovery

When you hear people talking about databases, it may seem confusing at first. Here is some background information to give you a head start researching what is best for your situation. A database is a collection of data arranged together to make it easier and quicker to find specific information.

They are used in many applications and are the preferred method of storage for multi-user applications. They are also convenient for single users. Having information stored on a separate database can also help you if need to recover deleted files.

Of all the databases available, the most popular is the relational database. A relational database makes it much easier to find information because it utilizes a set of tables to store information. The tables are made up of columns that store the information.

A hierarchal database is different in that it stores and organizes data in a tree like structure with an upward link to each saved record. Yet another type of database model is the network model. This type of database stores its data with links to other saved data records. Whether it is lost data or just the need to backup data, a database can be the answer.

There are several methods you can choose from for backup and recovery of databases. Some deal with full backup and some deal with selective backup. Make a checklist of files on your computer. This will help you decide what to backup and what is not really necessary or important, in case of lost data.

Full backups are exactly as they sound; a full copy of the database is stored on the backup media. Full backups can be done without taking the database offline. Full backups can take longer to complete than some of the others.

Next we have what is called the differential backup. The differential backup only stores a copy of the data that has changed since the last full backup was completed. It is very important to remember that if you do have a database failure, since a differential backup would not be helpful with recovering lost data. You would need both the full and differential backups to restore your database properly.

If you regularly make backup copies of your files and store them in a separate, safe place, then you can get most if not all of your information back if something happens to your originals. Transaction logs track all configurations that are done within your database, even unfinished transactions. Binary logs contain all events in the database that did or could contain modified data. Binary logs are used to support server replication and can be used as backup.

The best backup method depends on the storage engines used by the databases. You have several options for storing your backup copies. The CD-RW allows you to burn your files onto a compact disc. The DVD-RW burns your files onto a DVD.

Then there is the USB flash drive. This is a small hard drive that plugs into any available usb port on your computer and allows you to transfer your files. There are also online storage and backup services. You can save your files online and you can access them anytime you need them. Even though all the information may seem confusing, taking time to do some research will make it less daunting.

Original Source

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>