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 10.3 Restore Function Overview
Using the "Figure 10.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 10.4 Example of restore
