IT Questions and Answers :)



A message to our readers about COVID-19

With the uncertainty surrounding the outbreak of the corona virus. We want to reassure our reader stay safe and Healthy.Be aware and alert. Work as one nation. Sanitize and disinfect all equipment before entering your home, work and anywhere.

Wednesday, November 20, 2019

In SQL Server, what is backward recovery?

In SQL Server, what is backward recovery?

  • Switching to an existing copy of the database
  • Applying after-images to the database
  • Applying after-images and before-images to the DB
  • Applying before-images to the database 
In SQL Server, what is backward recovery?


Backwards recovery can be thought of as simply restoring the last saved point. Forward recovery is often about starting from the last saved point and then applying transactions that are newer than the save point, i.e. you are now forward of the save point.

Backward Recovery. Backward recovery restores a journaled database to a prior state. Backward processing starts by rolling back updates to a checkpoint (specified by -SINCE or -AFTER) prior to the desired state and replaying database updates forward till the desired state.




Post a Comment

Popular Posts