Step 2. Specify Restore Point

At this step of the Instant Recovery wizard, select a state as of which you want to restore your database:

  • Select the Restore to the point in time of the selected image-level backup option to load database files as of the moment when the current restore point was created.
  • Select the Restore to a specific point in time option to load database files as of the selected point in time. Note that this option is available only if archived log backups exist. For more information, see Required Backup Job Settings.
  1. Use the slider to choose a required point in time.
  2. If you want to load database files exactly as of the moment before undesired transactions, select the Perform restore to the specific transaction check box. Note that this option requires a staging server where Microsoft SQL Server is deployed. For more information, see Configuring Staging SQL Server.

Specifying Restore Point