Restoring a Database from Backup

Written by George Hingle

Last month we discussed the benefits and procedures of backing up your data. Now we are going to go through the steps of restoring a backup. In this process we assume that you have a working version of CBAS and only the data from the database somehow became corrupt. If this is not the case then you may have to reinstall CBAS before you can restore the database.

If you are restoring a backup from another computer, place the backup file in C:CBASBackups using Windows Explorer. If you already have a database open, you will have to close it in order to restore a database. To do this, go to the System Menu and click on Close Database. Now you will only have Database and System on the Main Menu. From here select Database and then Restore Database. The Restore Options window will then open.

The first line is Backup File and in most cases you will find that this line already lists the directory and file name of your most recent backup file saved to the hard drive. If you backed up your database to other media such as a floppy disk or CD, you will have to manually select the file path and file. In order to do this, select Pick at the end of the same line. A new window will open where you can browse for your backup file. Select the zip file you would like to use to restore your database.

At the bottom of the Restore Options window you should see a button labeled Restore. When you click it, a new window will open.
This is where you will select the folder of the database you want to restore. Again, it should be pointed to your existing database. In the case that you had to reinstall CBAS or you have never opened this database before, you will have to create a folder for the database before you start the restore process. Use Windows Explorer to make the folder in C:CBAS. Once you select the destination folder for the restore click OK and the restore will begin.

Now we move on to restoring your graphics. While CBAS does not automatically restore the pictures, it is fairly easy to restore them manually provided you followed the steps in lasts month’s article to back them up. This process requires using Windows Explorer to move around the file structure. First navigate your way to the CBAS directory and locate your database folder. In a new window locate the backup copy of the graphics folder you created. Now simply highlight and Copy (Ctrl +C) the backup graphics folder. Switch back to the CBAS directory, highlight your database folder and Paste (Ctrl+V) the copy in the directory. When you return to CBAS all of your graphics should be restored.

  • Was this article helpful?
  • Yes 0 people found this article helpful.
  • No 0 people did not find this article helpful.
  • Give us feedback

Restoring a Database from Backup