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 ||