Define Rollback and Rollforward?

 Posted by Tripati_tutu on 11/3/2010 | Category: Sql Server Interview questions | Views: 14418 | Points: 40

Rollback: The Rollback transaction is a transaction which rolls back the transaction to the beginning of the transaction. The transaction can be rolled back completely by specifying the transaction name in the Rollback statement or to cancel any changes to a database during current transaction. It is permissible to use before Commit transaction.

Rollforward: Recovering a database by applying different transactions that recorded in the database log files. It is nothing but re-doing the changes made by a transaction i.e. after the committed transaction and to over write the changed value again to ensure consistency.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response