TWiki > TWiki > HP3000FAQ > HP3000OperatingSystemQuestions > Hp3000Databases > Hp3000DatabaseLogging > Hp3000RollForwardVsBackward	TWiki webs: Main | TWiki | Sandbox
	TWiki . { Welcome | Register | Changes | Topics | Index | Search | Go }

Roll Forward vs. Roll Backward Database Logging on the HP3000

The basic procedural difference is:

Roll forward recovery:

* A database is restored from a set of backup tapes

* Transactions from the log file (from the date/time the backup was taken until the present time) are applied to the database

Roll Backward recovery:

* Transactions from a log file are "undone" (i.e. backed out) from a live database until a given "state" or point in time is reached Each method has it's advantages and disadvantages.

For instance, a database which is structurally "damaged" would likely need to be restored from a backup media, and transactions applied to it to "bring it up to date" (roll forward).

On the other hand, a database which is structurally intact but has been "damaged" by erroneous processing (perhaps someone accidentally deleted all of the week's orders) could use the log files to "roll back" the database, undoing the transaction(s) that corrupted the database, or back to a point in time before the error occurred.

-- ChrisBartram - 18 May 2006

Parents: Main > HP3000FAQ > HP3000OperatingSystemQuestions > Hp3000Databases > Hp3000DatabaseLogging

Copyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors. Ideas, requests, problems regarding TWiki? Send feedback Note: Please contribute updates to this topic on TWiki.org at TWiki:TWiki.Hp3000RollForwardVsBackward