Restoring an MS SQL database

Procedure
  1. Click HPE Recovery Manager Central > Microsoft SQL.
  2. Click the Databases tab and then select the database that you want to clone.
  3. From the Actions menu, click Clone/Restore or in the Copies panel, click Clone/Restore.
  4. Select one of the following options 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.
    • Restore (Point of failure) — Restores data to the parent volume. The selected snapshot or backup overwrites the existing data. Point-of-failure recovery is useful if you cannot afford to lose any data during a system failure.
  5. Perform the corresponding steps based on your selection in the Clone/Restore screen.
  6. For Restore (Point in time):
    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 Type — To Parent Volume or File Copy.
      NOTE:

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

    5. If you select the No Recovery option, a rollback cannot occur.
  7. For Restore (Point of failure):
    1. By default, Restore (Point of failure) picks the most recent snapshot available for restore.
    2. Select the Restore Type — To Parent Volume or File Copy.
      NOTE:

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

    3. If you select the No Recovery option, a rollback cannot occur and during the restore operation, the database is moved to restoring mode.