Restoring an MS SQL database

Prerequisites

To add databases to Availability Group, ensure that there is a datapath from the storage system to the host for all the Availability Groups.

Procedure
  1. Click HPE Recovery Manager Central > Microsoft SQL.
  2. From the Actions menu, click Clone/Restore or in the Copies panel, click Clone/Restore.
  3. 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.
  4. Perform the corresponding steps based on your selection in the Clone/Restore screen.
  5. 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 Available Copies section and then click Next. You can use the First, Previous, Next, and Last buttons to navigate among pages that contain the Available Copies list.
    3. Select the Copy that you want to restore and then click Next.
    4. Select the Restore Type:
      • To Parent Volume— Restores the original volumes of the database. This type of recovery is useful in recovering from logical errors.

        NOTE:

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

      • Using Database File Copy— Copies database files to the original location or to a specified location.

        NOTE:

        This restore type is not supported for a Cloud Copy.

    5. In the Advanced Options, select the Add to Availability Group option to add databases to Availability Group. Specify Backup Share and Availability Group.
    6. Select the No Recovery option if you want to restore databases in restoring mode.

      You can replay transaction log backup to recover the databases.

    7. (If the selected Copy is a Transaction Log) Select one of the following options:
      • Transaction Log only— Restores Transaction Log only if the database is restored using the no recovery mode. Use the No Recovery option for parent Copy and then restore Transaction Log using the Transaction Log only option.

      • Replay Transaction Log upto— Replays Transaction Log up to the specified time. Specify Date and Time.

  6. For Restore (Point-of-failure):
    1. By default, Restore (Point-of-failure) picks the most recent Copies available for restore.
    2. Select the Restore Type:
      • To Parent Volume— Restores the original volumes of the database. This type of recovery is useful in recovering from logical errors.

      • Using Database File Copy— Copies database files to the original location or to a specified location.

      NOTE:

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

    3. In the Advanced Options, select the No Recovery option if you want to restore databases in restoring mode.

      You can replay transaction log backup to recover the databases.

  7. Click OK.