FWIW, I respect Jack and his approach to backup is pretty good but there's one major flaw. that a lot of professionals, let alone individuals also suffer with.
The log files don't tell you if what you're backing up is good or garbage and they don't tell you if it's restorable.
There is a huge difference between having a log file that says something is backed up and actually being able to restore it.
Even a verify isn't a guarantee that your backup is good.
I've seen clients with boxes of backups which contain nothing but log files or the master is corrupted leaving only the incrementals, nothing at all or any other combination of worst case scenarios you can imagine including DAT tapes that previously restored correctly but were written on a misaligned DAT drive so they could not be read on a correctly aligned drive.
The IRA bombing of Manchester brought that one to light because the client's misaligned drive was buried under a few tons of rubble along with their Netware server (yes, I am that old)
So, I would highly recommend to anyone who is creating a backup/disaster recovery plan that they include a periodic restore of the backed up data and a sanity check of the restored data which means actually examining the files you've restored.
Having worked at more than one financial institution in my time, I have been exposed to backup issues and, more particularly, Disaster Recovery Planning.
What CJay has posted is a basic outline of the greater subject of backups - with the ominous but vital question that everyone who
does backups really should address.... and it will go something like this:
Will your backups allow you to recover the way you expect them to?If you don't have an idea of how you 'expect' them to work, then you have a problem from the get-go.
There are all sorts of situations where recovery from backups will be needed, from accidental deletion of a file to the incineration of a building. You need to assess what possibilities are relevant to your situation and plan accordingly.
However, once you have these things in place - how do you know they are going to work?
The only answer is to do a trial recovery. Yes, it's a pain ... it will take time and be inconvenient, but until you've done it, you cannot KNOW it will be successful.
The other thing is .... you mustn't cheat, especially if you are looking at a full recovery from a disaster event.
First step is to quarantine the primary site. You are not allowed to go in to grab any software install disks or serial keys and you can't call someone to look anything up for you. (I once worked for a company that did a recovery exercise and even told the guy who knew all the nitty gritty to stay at home that day and not answer his phone.)
Find another location to set up. Then, go out and buy a new box together with the necessary hardware, grab your off-site backups and see if you can get the system running as required.
This is where you will find out if you have really backed up properly and that the backups are readable....
Did you miss a software patch? ... a little text file or spreadsheet? ... that post-it on the filing cabinet with your access details to a supplier?
If you don't do something to verify that you can
actually complete a recovery then you are driving down the information highway without brakes.