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 (One Point Copy) of the advanced copy function:
restoring database files,
recreating a database,
applying transaction logs,
Figure 8.3 Restore Function Overview
Using the example scenario in the above figure, the diagram below shows how to perform restore up to the latest point when a failure occurs before the log backup on Friday:
Figure 8.4 Example of restore
