Restoring an MS SQL instance

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. 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.
  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 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 Instance File Copy— Restores a specific instance from Snapshot to either the parent MS SQL server or to an alternative MS SQL server.

        NOTE:

        This restore type is not allowed for a Cloud Copy.

    5. 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 to restore databases in restoring mode.

      For using the No Recovery option, the instance Snapshot can contain only user databases. System databases cannot be in no recovery mode.