In the last few weeks, I have had to help 2 different customers recover from major hardware problems. In both cases their backups failed - although for different reasons. In the first case, the backup was running but not backing up the correct information. In the second case, the backup was functioning as it should, but wiped out the good backup, with a backup of "nothing". These two instances led me to write this article about backup procedures.
What do I back up?
The most fundamental part of any backup plan is ensuring that you are backing up the correct data. Regardless of what backup solution you utilize, be sure that you are backing up the following directories. Your data can be spanned across multiple drives, so check each drive for these directories:
- enetdata1
- data_discreports
- data_netreports1
Enlighten.Net software uses SQL Server to store some data. This data should also be backed up regularly. To facilitate this, your Enlighten.Net/Net.DFM server should have a scheduled task that backs up the SQL database to a flat file in the enetdata1 directory. You should confirm that this task runs successfully nightly.
Likewise, we have installed a second scheduled task that backs up the configuration files and registry to the enetdata1 directory.
How often do I back up?
The obvious answer to this question is to backup each night. However, in some cases a nightly backup of all data won't complete before the work day starts again. In this case, you can do a full back up on the weekend and only backup the data that was added or changed since the last backup was run. A full backup is the easiest to use when recovering from a complete disaster, but takes up more space on the backup device, and takes longer to backup. Consult the documentation for your backup software for details on backup strategies.
What do I backup to?
10 Years ago everyone backed up to tape drives. In many cases however, tape drives are not large enough to hold a full backup. Tapes that are large enough are prohibitively expensive. External USB devices are the most common backup device for small to medium size businesses. Regardless, you should alternate the backup device on a rotating schedule. I recommend 3 or 4 devices to be certain that you don't overwrite a back up too soon. Lastly, you should take the devices that are not in use out of the office so that in case of a total disaster (flood, theft, etc) you still have your data.
Did it work?
All good backup software will generate a report that gives you the results of the backup, the size of the backup and how long it took. You should review this information frequently. If one report varies greatly (duration or storage used), you should investigate further and not consider that backup successful.
How do I restore from the backup?
During an emergency, you do not want to find out that you don't know how to restore the files you need. You should periodically restore a file or two to test the backup and your procedures for restoring.
Now what?
This was a quick overview of the issues you should be thinking about in regards to your backup and is not intended to be a comprehensive look at this subject. If you would like assistance with this topic, please contact Customer Services. Please note that designing, testing or implementing backup solutions is not included in any of our service plans and will result in additional fees.