complete recovery (also called roll-forward recovery)

Complete recovery builds on a restored database and allows you to rebuild a database to a specified point in time. For example, if a disk failure occurs on the disk containing your database, you can restore and then roll forward the database to recover the updates as near to the point of failure as possible.

If an application problem corrupted your database, or accidentally deleted data, you can recover it by restoring and then roll forward to the point in time just before the application destroyed your data. Losing all the changes made after that point in time may be preferable to losing the earlier data.

If you choose to stop rolling forward and make the database ready for use, be careful because once you click Finish you will not be able to continue rolling forward. Since a new log file is created that may overwrite an existing one, you may want to make a copy of your log files and your database backup image before you complete your roll forward.