To restore using the No Recovery option

1. Ensure that you have backed up the transaction logs within SQL Server using the "overwrite existing media" option to create uniquely-named backup files.
2. Close the SQL GUI and all Explorer windows, applications, consoles, or third-party system management tools that may access the database volumes. It is also recommended to bring the database offline.
3. From the VEA console, navigate to the system where the database volumes are located.
4. Expand the system node, the Storage Agent node, and the Applications node.
5. Right-click SQL and click VSS SQL Restore.

   Review the Welcome page and click Next.

6. Select the snapshot set XML metadata file to be used for this operation and click Next.

   The XML metadata file contains all information that is required to restore the snapshot set, including the names of the database and transaction logs volumes. Click the appropriate header to sort the list of available files by File Name or Creation Time.

7. On the Select Restore Type panel, click No Recovery and click Next.
8. You may receive a message "Some volumes in this component have open handles. Do you want to override these handles and do this restore? Click Yes to proceed." Click No, close any open handles and retry the command.
9. Verify the restore specifications and click Finish.

   The database and log snapshot volumes are restored and the SQL Server database is left in a loading state.

10. Use your preferred method to manually restore the backup transaction logs to the desired point in time and then bring back the database online.
11. The restore operation leaves the snapshot volumes snapped back to the production volumes. To ensure that another split-mirror snapshot set is immediately available, use the VSS Snapshot Wizard to create a new snapshot of all the volumes in the database.