Loading...

Cloning a SQL Database

You can use the cloning feature to do the following operation:

  • Duplicate large databases in a short amount of time
  • Create test environments
  • Retrieve data quickly without intensive resource use on the production environment
  • Alleviate the load on production servers

You can create a clone from a full IntelliSnap backup. When you create a clone, you must specify the reservation period. The system automatically shuts down the clone database and frees up all resources when the reservation period expires.

Procedure

  1. You can clone a database on the instances page, or the manage clones page.
    • Manage clones: From the navigation pane, click Solutions > DB Instances >instance. In the upper right of the page, click Manage clones. Then on the Manage clones page, click Create clone.
    • Instances: From the navigation pane, click Solutions >DB Instances , in the Actions column for the instance, click the action button action_button, and then click Instant clone.

      The General information page appears.

  2. Determine the backup that you want to clone.
    • To clone the database from the most recent time, in the Recover to area, select Most recent backup.
    • To clone the database from a point in time, under Recover to, select Point in time. Then in the From time and To time boxes, click the calendar and specify the dates.
  3. Click Next.

    The Content selection page appears.

  4. In the Database name section, select the database that you want to clone.
  5. Click Next.

    The Destination Details page appears

  6. Provide the destination information.
    1. From the Destination server list, select the client that you want the clone to be on.
    2. In the Snap mount path box, type the full path to the destination server folder where the software mounts the snapshot.
    3. In the Target database name box, type the name of the clone database.
  7. Click Next.

    The Clone options page appears.

  8. Provide the clone options.
    1. In the Clone reservation boxes, type the number of days and hours that the software retains the clone environment.
    2. To have the software clean up any existing clone on the destination that has the same database name, regardless of the reservation period, select the Unconditionally overwrite existing database files check box.
  9. Click Next.

    The Summary page appears and lists the selections.

  10. Click Finish.

Result

The software creates a clone on the destination server that lasts for the reservation period.

What to Do Next

You can control or view the job. For more information, see Jobs.

You can manage your clones, for example, extend the reservation period. For more information, see Managing SQL Clones.

Last modified: 3/10/2018 7:53:37 PM