Cloning 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:
    • 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 and then creates a Copy of the database.
    • 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.
    NOTE:

    Maintain cluster mount path separate for database clone from the volume where the instance or database resides. This approach is suggested because the disk goes to a maintenance mode when the clone operation is performed and attach operation fails to find files associated with the instance or database.

  6. For Virtual Clone from a new Snapshot:
    1. If you do not want to mount the Clone or create a database Clone, clear the Mount and Database Clone options.

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

    2. Click Select Instances, select instances, and then click Add.

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

      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. 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.

    4. Specify a Mount Point for mounting the Clone.
    5. Specify a Target Database Name and then click Clone.
  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 a database Clone, clear the Mount and Database Clone options.

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

    4. Select a Target Instance.
    5. Specify a Mount Point for mounting the Clone.
    6. Specify a 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:

      Physical clone creation depends on the number of volumes in the Volume Set. Also ensure that the size of the volumes is greater or equal to the Volume 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. The default Clone Level setting creates instant Clone of the database with the mounted Copy.
    4. Select a target instance.
    5. Specify a Mount Point for mounting the clone.
    6. Specify a Target Database Name for clone.
    7. Click Clone.