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 per date when the current restore point was created.
- Select the Restore to a specific point in time option to load database files as per selected point in time. Note that this option is only available if archived log backups exist. For more information, see Required Backup Job Settings.
- Use the slider to choose a required point in time.
- If you want to load database files exactly as of the moment before undesired transactions, select the Perform restore to 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.