News for hackers. Stuff that matters.
Re:An administrator accidentally deleted the production data... by slavik81 on Wednesday March 23, 2016 @04:09PM (#11347778)
How do you do test your restore without destroying the only trustworthy copy of your data?
Re:An administrator accidentally deleted the production data... by ziziyO on Wednesday March 23, 2016 @04:25PM (#11347912)
Do it in the Staging or User Acceptance Testing environment.
Re:An administrator accidentally deleted the production data... by twic on Wednesday March 23, 2016 @08:15PM (#11349519)
This 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.
Re:An administrator accidentally deleted the production data... by vacri on Wednesday March 23, 2016 @08:20PM (#11349552)
A friend of mine has his staging databases restored every morning (and anonymised) from the previous day's production backup.
Re:An administrator accidentally deleted the production data... by jlgaddis on Wednesday March 23, 2016 @05:57PM (#11348598)
Restore it elsewhere.