Making Data Backups
|Top Previous Next|
As with any software program, it is vital to safeguard your data. You can lose it due to hardware failure, or software problems. There may even be bugs in this software which have not yet been discovered which could damage your data (although I certainly make the best possible efforts to avoid that eventuality!). In addition, you might accidentally make some wrong entries or menu choices in the program which you want to undo in a simple manner.
The only sure safeguard against any of these problems is to make regular backups, which should normally be done using Backup/Restore à Backup Database. Note that if you do regular backups of your hard disk outside of the DONATION program, the database will also be successfully backed up, as long as the DONATION program is not running at the time the backup is made, and DONATION's data directory and all of its subdirectories are included in the backup. (However, those backups would be an actual copy of your database file, not the same type of backup as is made with Backup/Restore à Backup Database and restored with Backup/Restore à Restore Database.)
An alternative to using Backup/Restore à Backup Database is to use Backup/Restore à Email Backup to email a compressed and encrypted backup to an email address, which could be your own, or a colleague's.
The first time you make regular backups in the program, with the Backup/Restore à Backup Database menu option (or when you are first prompted to do a backup as you are exiting DONATION), you will be asked whether you would like to set up to do Internet backups as well, after each regular backup. This allows you to keep another copy of your last three backups, in a secure location on the Internet.
It is important to understand that once you have multiple years of data in DONATION, all of those years of data are always backed up together, by either type of backup. There is no way to backup only one year of data.
My general rule about how often to back up is based on how much you would hate re-doing your work. If you put in a set of entries on one day, and you hate the thought of having to re-enter them if something goes wrong, make a backup immediately and you are protected. If you make few enough entries that you could bear the thought of re-doing a whole month's work if something went wrong, you can do your backups once a month.
The backup procedure is simple. Select Backup/Restore à Backup Database. A "Save Backup File As" dialog box then appears, where you select the drive and/or directory to save it in. You can use this option to back up to a USB memory key, your hard drive, a diskette drive (A:), a writeable CD, or a shared directory on a local area network. You can create new subdirectories in this dialog box, by clicking into the box for files, right-clicking your mouse, and selecting New à Folder.
I strongly recommend you to not do your backups to a directory on your local hard drive (C:). If you do only that, and your hard drive dies (which happens surprisingly frequently!), you will have lost everything. And in fact, if you do that, the program warns you about this, and asks you to confirm that this is really what you want to do.
The default backup file name is DONATION-YYYY-MM-DD.DB.GBK, where the YYYY-MM-DD part is replaced by the current date, in that format. (Earlier versions used the backup file name DONATION4.DB.GBK, with no date component.) You can also change that file name in the "Save Backup File As" dialog box, as long as it ends in the same ending, ".DB.GBK". If you have used the Database à Switch Databases option to use a different database for another organization with a different file extension (e.g. if your database is DONATION4.ABC), then the default backup file name will be DONATION-YYYY-MM-DD.ABC.GBK, and if you change that name, you will still have to leave it ending in ".ABC.GBK". If you have multiple databases created with Database à Switch Databases, each must be backed up independently, and the program warns you of this fact any time you backup one of them.
If you make more than one backup in a given day, the backup file names you are prompted with will be given sequential numbers, so for instance for December 31, 2011 the first backup would be DONATION-2011-12-31.DB.GBK (with no sequential number added) and the second will be DONATION-2011-12-31.2.DB.GBK (with the ".2" added).
If there is a previous backup with exactly the same name in the location you selected, the program will prompt you to confirm that it is OK to replace the old one before making the new backup.
If you select to backup to a 1.44MB diskette in the A: drive, the program will determine whether the backup will fit on that drive and give you an error message if it will not. Backup files are actually smaller than the working database file, because the database file contains some extra blank space for easy expansion, whereas the backup file does not. So this actually means that even though your database file is significantly larger than 1.44MB, the backup may indeed still fit on a diskette. After backing up to a diskette, make sure you put an appropriate label on the diskette, such as "Backup of DONATION program data" plus the date.
After you have made the backup, the program will inform you whether it was successful, and if it wasn't, it will display any error messages
Note: The "Save Backup File As" dialog box will always initially display the previous drive and directory into which you saved a backup using Backup/Restore à Backup Database. The first time it is used in a new install of DONATION, it will default to the Backup subdirectory of your Data Directory. on your main hard drive. However, although it is not a bad idea to backup to that directory (or any other selected directory) on your hard drive, as mentioned above you really need to also backup elsewhere (e.g. to a USB memory key, diskettes, a writeable CD) in case your hard drive ever fails.
Note: Database backups made with versions of DONATION prior to version 3.00 cannot be restored with the standard Backup/Restore à Restore Database menu option to version 3.00 or later, because a different database format was used. Those backups are named DONATION3.DB (or DONATION3.something if you have multiple databases.) To restore them, use Backup/Restore à Restore Old Database.
Opening / Using Backup Files
Backup databases created via Backup/Restore à Backup Database can be restored by double-clicking on them in a My Computer or Windows Explorer window, as long as DONATION is not currently running. This will cause DONATION to open, and prompt you as to whether to restore the backup. (See Restoring Backups for details on how this works.) They can also be restored directly within the DONATION program by using the Backup/Restore à Restore Database menu option. There is no way other than restoring a backup to DONATION to access the data in it.
Backing Up to Network Paths
If you want to backup to a drive on another computer on your network, you must map a drive letter to that drive on your computer, and backup to that drive letter. You cannot use what are known as UNC paths.
For instance, if you want to backup to the share named CDrive on the computer OtherComputer, you can't specify \\OtherComputer\CDrive\pathname\DONATION-YYYY-MM-DD.DB.GBK in the Save Backup File As dialog box. You will get an error message about not being able to save the backup if you try that. Instead, in My Computer use the Tools à Map Network Drive menu option to map \\OtherComputer\CDrive to a drive letter, such as Z:. Then in DONATION, you just backup to Z:\pathname\DONATION-YYYY-MM-DD.DB.GBK, and it should work.
Warning about Using Standard File Copies
Although you can also successfully back up and restore your database file (donation4.db) just by using standard file copying methods (e.g. using My Computer, Windows Explorer, or the COPY command in a Command Prompt), or via specialized backup software, do not do this while you are running DONATION! That could possibly lead to your database becoming damaged and unusable.
By default, the program reminds you weekly to backup your database, as you are exiting the program. If you wish to be reminded with a different frequency, you can use the Backup/Restore à Backup Frequency and Options window. This gives you the option of Never, Daily, Weekly, or Monthly. If you don't set it, it defaults to Weekly.
If you have not done a backup within the configured period of time (with either Backup/Restore à Backup Database or the Backup/Restore à Email Backup option), you will be prompted to do a backup the next time you exit the program.
Deleting Old Backups
Because each backup is by default given a distinct name, including the date it was made, the backups will tend to accumulate in whatever drive and directory you are saving them. To allow you to control this, that same Backup/Restore à Backup Frequency and Options window gives you an option to either retain all backups, or retain only the latest "N" backups in each backup directory, where you set the value "N" (between 3 and 20). If you do not set this, the default is to retain all backups.
If you do set that value, whenever you make a backup, the other backups in the same directory are examined, and only the most recent "N" of them are kept, with the older ones being deleted.
Note that even if you do set this, only backups whose name starts with "DONATION" will ever be deleted. This gives you a way to force certain backups to be retained indefinitely - just edit their name as you are making them to insert something before "DONATION". For instance, you might name a year-end database "2011YearEndDONATION-2011-12-31.DB.GBK", instead of just "2011YearEndDONATION-2011-12-31.DB.GBK".
Backing up for users of the Network Version
For users of the normal single-user version of DONATION, or the Network Server version, backups work exactly as described above. However, for users of the Network Client version (where the database is on another computer running the Network Server version), it is quite different.
When you do a backup from the Network Client version, the backup is not done on your computer. Rather, your computer sends an instruction to the computer running the Firebird Server (which is part of the Network Server version of DONATION), to do the backup. The backup is of a database file on that server computer, and must backup to another file on that server computer.
Because of this, the normal "Save Backup File As" dialog box cannot be used, because that dialog box refers to files on (or visible from) your computer, whereas the backup will be done to a file on the server computer. So instead, a simple window comes up, titled Network Backup, which prompts you to type in the full path and filename, relative to the server computer, to backup to. In addition, unlike for other users, it cannot tell you whether that backup file already exists and prompt you as to whether it's OK to replace that backup file. If the backup file already exists, it just automatically overwrites it.
Because of these limitations, it is easier to always do your backups for the network version from the computer running the Network Server version of DONATION.
The Backup Reminders apply to all users, including users of the Network Client version of DONATION. However, if you are using the Network version, there is only one database, so really, only one user needs to be regularly backing up the database. So, you may want to change the Backup Reminder Frequency for the other users to Never.
The setting mentioned above to retain only the latest "N" backups also does not apply (and thus cannot be set!) for the Network Client version of DONATION, because it cannot "see" the other backups on the Network Server version's computer, in order to decide which to delete. (And it couldn't delete them either.)
See Also: Restoring Backups