Many years ago I worked for a company that had a tape backup system they sold with their computers.

Due to a firmware screw up for few months the backup tapes were written blank and then when they were verified they verified as good.

Fortunately none of the banks that were using the systems had a problem in that few months.

In this case  Schrödinger's backup was dead,alive and invisible.

Regular testing is important.



On 12/23/2016 03:36 PM, Mauro Souza wrote:
If you don't test, you will have a Schrödinger's backup: both valid and invalid at the same time, until you try a restore. 

On Dec 23, 2016 6:20 PM, "Alvin Starr via talk" <talk@gtalug.org> wrote:
On 12/23/2016 02:59 PM, Stephen via talk wrote:
With the discussion about backups, I would like to raise a question I have had for some time.

Having backups does no good if you cannot restore them. Files are rather easy to test.

But how do you test restoring a database?

I back it up with the usual tool. I have the docs to do the restore.

But how to test to make sure that restoring works, without clobbering the active database?

Thank you

you can recover on a different machine or start a second instance of the database on different ports.
This is the kind of place where virtualization or containerization comes in handy.

Testing your backups is always a good idea.

-- 
Alvin Starr                   ||   voice: (905)513-7688
Netvel Inc.                   ||   Cell:  (416)806-0133
alvin@netvel.net              ||

---
Talk Mailing List
talk@gtalug.org
https://gtalug.org/mailman/listinfo/talk


-- 
Alvin Starr                   ||   voice: (905)513-7688
Netvel Inc.                   ||   Cell:  (416)806-0133
alvin@netvel.net              ||