| are not familiar with how databases work, then it can | | | | offline. |
| seem a little overwhelming in the beginning. It can all | | | | Full backups can take longer to complete than some |
| be simplified with a little information. A database is | | | | of the others. Next we have what is called the |
| collected data arranged in a specific way, making it | | | | differential backup. The differential backup only |
| simpler and easier to find data when needed. While a | | | | stores a copy of the data that has changed since |
| data base can be used for single user applications, | | | | the last full backup was completed. |
| they are very helpful for systems that have | | | | It is very important to remember that if you do |
| multi-users. | | | | have a database failure, since a differential backup |
| The most popular type of database is the relational. | | | | would not be helpful with recovering lost data. You |
| This type of database makes it easier to find and | | | | would need both the full and differential backups to |
| sort specific information. Tables are used to store | | | | restore your database properly. |
| information. Each table contains a column or multiple | | | | If you regularly make backup copies of your files and |
| columns to store information that can be found easily | | | | store them in a separate, safe place, then you can |
| when needed. The original databases were flat and | | | | get most if not all of your information back if |
| information was filed in one long text file. | | | | something happens to your originals. Transaction logs |
| Each entry contained several pieces of information | | | | track all modifications that are done within your |
| about a subject. However, the text files in a flat | | | | database, even unfinished transactions. |
| database made it harder to find specific information | | | | Binary logs contain all events in the database that did |
| quickly. There is also something called a hierarchical | | | | or could contain modified data. Binary logs are used |
| database. | | | | to support server replication and can be used as |
| Data is organized in a tree like structure using an | | | | backup. |
| upward link in each record. The network models | | | | The method of backup that works best for you will |
| store records with links to other records. Here are | | | | depend on databases storage engines. There are |
| some tips that can help you to recover data with | | | | several backup services methods available and a little |
| your database. | | | | info will help you choose the right one for you. You |
| There are several methods you can choose from for | | | | may choose to use a CD-RW or a DVD-RW. |
| backup and recovery of databases. Some deal with | | | | These mediums are used to backup data onto either |
| full backup and some deal with selective backup. | | | | a compact disk or a DVD. Another option to recover |
| Make a checklist of files on your computer. | | | | data is the USB flash drive. |
| This will help you decide what to backup and what | | | | The flash drive is a mini hard drive that will plug |
| isn't really necessary or important, in case of lost | | | | straight into any usb port on your computer, allowing |
| data. Full backups are exactly as they sound; a full | | | | you to download your files directly to it, or vise |
| copy of the database is stored on the backup media. | | | | versa. You may also wish to store your files using an |
| Full backups can be done without taking the database | | | | online storage system. |