<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
On 12/23/2016 02:59 PM, Stephen via talk wrote:<br>
<blockquote
cite="mid:ff770e87-ebbb-d04e-3b3c-6bef140ad3c4@rogers.com"
type="cite">With the discussion about backups, I would like to
raise a question I have had for some time.
<br>
<br>
Having backups does no good if you cannot restore them. Files are
rather easy to test.
<br>
<br>
But how do you test restoring a database?
<br>
<br>
I back it up with the usual tool. I have the docs to do the
restore.
<br>
<br>
But how to test to make sure that restoring works, without
clobbering the active database?
<br>
<br>
Thank you
<br>
<br>
</blockquote>
you can recover on a different machine or start a second instance of
the database on different ports.<br>
This is the kind of place where virtualization or containerization
comes in handy.<br>
<br>
Testing your backups is always a good idea.<br>
<br>
<pre class="moz-signature" cols="72">--
Alvin Starr || voice: (905)513-7688
Netvel Inc. || Cell: (416)806-0133
<a class="moz-txt-link-abbreviated" href="mailto:alvin@netvel.net">alvin@netvel.net</a> ||
</pre>
</body>
</html>