The SQL Server restore execution command recreates a database using the database files restored from a database backup. The following series of processes can be completed in a short time by using OPC of the Advanced Copy function:
restoring database files
recreating a database
applying transaction logs
Figure 9.3 Restore Function Overview
Using the "Figure 9.2 Example of backup operation", the diagram below shows how to perform restore up to the latest point when a failure occurs before the log backup on Friday:
Figure 9.4 Example of restore
