2

Occasionally we have an issue where a record's previous data might get wiped while editing.

We backup our database every night for issues like this, however sometimes I am not available to do a restore immediately.

I've been asked to create a tool our editors can use to restore a record from a previous backup file.

I imagine this would look a lot like the a Webmin panel, which leads me to believe I may be reinventing the wheel. However, our editors find Webmin difficult to work with, so this isn't a solution for us.

Is anyone familiar with something we can use for the purpose of restoring a single record?

If not, are there any best practices I should abide by?

1 Answer 1

0

Restore is overkill.

I'd use history/change tracking within the database/application itselF: then "rollback" becomes a standard day to day business or support actions

This would be with history tables, or Slowly Changing Dimension type 2 tables, to store "old" versions of rows. Perhaps with some schedules clean-up to purge older versions

2
  • Thanks. So I would be able to use a trigger to track with the history table?
    – Yazmin
    Mar 6, 2012 at 3:10
  • @Yazmin: yes, this is the easiest way
    – gbn
    Mar 6, 2012 at 7:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.