Cloning using an MS SQL instance

Procedure
  1. Click HPE Recovery Manager Central > Microsoft SQL.
  2. Click the Instances tab and then select the instance.
  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:
    • Virtual Clone from a new Snapshot — Creates a snapshot of the database in the current state. The Clone of the database is created from the newly created snapshot.
      NOTE:

      There is no corresponding HpRmCli command for creating Clone from a new Snapshot.

    • Virtual Clone from an existing Copy — Clones the existing Snapshot or backup Copy and then creates a Copy of selected databases in the instance.
    • Physical Clone — Data is restored to a new volume.
    • Instant Clone (ERT) — A Clone is instantly created from the backup Copies.
  5. Perform the corresponding steps based on your selection in the Clone/Restore screen.
  6. For Virtual Clone from a new Snapshot:
    1. If you do not want to mount the Clone, clear the Mount option.

      The default Clone Level setting mounts the volume clone.

    2. Click Select Servers, select a server, and then click Add.

      You can use the Remove Selection option to exclude the selected servers.

      NOTE:

      Creating virtual Clones from database or instance-level Snapshots with multiple instances and a single mount point is not supported for cluster instances.

    3. Click Select Databases, select databases, and then click Add.

      You can use the Remove Selection option to exclude the selected databases.

    4. Specify the following details in the Snapshot section:
      Name

      Specify a name for the snapshot.

      Auto Delete After

      (Optional) Expiration time for the Copy. A Copy expires after the expiration time. The minimum time must be one hour. The maximum time can be 43,800 hours or 1,825 days.

      Prevent Deletion Until

      (Optional) Retention time for the Copy. You cannot delete a Copy until the retention time expires. The minimum time must be one hour.

    5. Specify a Mount Point for mounting the volume clone.

      The default mountpoint is C:\RMCSnapClones. For cluster configuration, specify a cluster-dependent disk.

  7. For Virtual Clone from an existing Copy:
    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 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. If you do not want to mount the Clone or create Instance Clone, clear the Mount and Instance Clone options.

      The default Clone Level setting mounts the Snapshot Clone and creates a Clone with the Snapshot Clone.

    4. Click Select Servers, select a server, and then click Add.

      You can use the Remove Selection option to exclude the selected servers.

    5. Click Select Databases, select databases, and then click Add.

      You can use the Remove Selection option to exclude the selected databases.

    6. Specify a Mount Point for mounting the volume clone.

      The default mountpoint is C:\RMCSnapClones. For cluster configuration, specify a cluster-dependent disk.

    7. Specify the Target Database Name and then click Clone.
  8. For Physical Clone:
    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 a storage system.
    4. Click Select Data Volumes, select volumes, and then click Add.

      You can use the Remove Selection option to exclude the selected volumes.

    5. Click Clone.
      NOTE:

      The number of volumes selected for the creation of physical clone depends on the number of volumes in the recovery set and also the size of the volumes must be greater or equal to the recovery set volume sizes.

  9. (Supported only for Express Protect and Catalyst Copy) For Instant Clone (ERT):
    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. If you do not want to create Instance Clone, clear the Instance Clone option.

      The default Clone Level setting creates instant Clone with the mounted backup Copy.

    4. Specify Database and Target Instance.
    5. Specify a Mount Point for mounting the volume clone.

      The default mountpoint is C:\RMCSnapClones. For cluster configuration, specify a cluster-dependent disk.

    6. Specify the Target Database Name and then click Clone.