Restoring an MS SQL instance

  1. Click HPE Recovery Manager Central > Microsoft SQL.
  2. Click the Instances tab and then select the instance that you want to restore.
  3. From the Actions menu, click Clone/Restore or in the Copies panel, click Clone/Restore.
  4. Select the option Restore (Point in time) and then click Next.
    Restore (Point in time) — Restores data to the parent volume. The selected snapshot or backup overwrites the existing data. Point-in-time recovery is useful for recovering from logical errors.
  5. Perform the following steps:
    1. Pick a date (color coded) from the calendar that contains the copies summary for a selected month.
    2. Select a copy from the list of available copies for the selected date in the Copies for clone section and then click Next. You can use the First, Previous, Next, and Last buttons to navigate among pages that contain the Copies for clone list.
    3. Select the Copy that you want to restore and then click Next.
    4. Select the Restore TypeTo Parent Volume or Using Database File Copy.

      If a Copy contains VMFS LUN, then you cannot restore data to the parent volume.

    5. If you select the No Recovery option, the transaction log cannot be replayed.