3 ms·
How do you do test your restore without destroying the only trustworthy copy of your data?
by slavik81 11y ago
How do you do test your restore without destroying the only trustworthy copy of your data?
- ziziyO 11y agoDo it in the Staging or User Acceptance Testing environment.
- twic 11y agoThis is the right answer! You want a staging/acceptance/mirror environment that's the same as production, right? So make it with nightly restores of the production backups. You get a crisp, fresh staging environment, and regular validation of your backups too. Just remember to run full production monitoring against your staging environment too.
- jlgaddis 11y agoRestore it elsewhere.
- vacri 11y agoA friend of mine has his staging databases restored every morning (and anonymised) from the previous day's production backup.