Skip to main content
SnapCenter Software 6.0

Clone SQL Server database backup

Contributors netapp-soumikd
PDFs

You can use SnapCenter to clone a SQL database using the backup of the database. The clones created are thick clones and are created on the parent capacity pool.

About this task

You should ensure that the target instance for clone is configured with an active directory user who belongs to the SMB ADactive directory domain and has permissions to set the file permissions appropriately. You should configure the credentials in SnapCenter at instance level.

The SQL authentication for target instance will not be supported for SMB configurations. The target instance should be configured in SnapCenter with the active directory user having the required permissions.

If the SnapCenter Plug-in services service account is not an active directory user then while performing clone, the user who have the full control over the source volumes is required so that it can be impersonated and perform the required operation.

Steps

  1. In the left navigation pane, select Resources, and then select the appropriate plug-in from the list.

  2. In the Resources page, select either Database or Resource Group from the View list.

  3. Select the database or resource group.

  4. From the Manage Copies view page, select the backup from primary storage system.

  5. Select the backup, and then select clone icon.

  6. In the Clone Options page, provide all the required details.

  7. In the Location page, select a storage location to create a clone.

    If the SQL Server database ANF volumes are configured in a manual QOS capacity pool, specify the QOS for the cloned volumes.

    If QOS for the cloned volumes is not specified, the QOS of the source volume will be used. If the automatic QOS capacity pool is used, the QOS value specified will be ignored.

  8. In the Logs page, select one of the following options:

    1. Select None if you want to clone only the full back up without any logs.

    2. Select All log backups if you want to clone all the available log backups dated after the full backup.

    3. Select By log backups until if you want to clone the database based on the backup logs that were created up to the backup log with the selected date.

    4. Select By specific date until if you do not want to apply the transaction logs after the specified date and time.

  9. In the Script page, enter the script timeout, path, and the arguments of the prescript or postscript that should be run before or after the clone operation, respectively.

  10. In the Notification page, from the Email preference drop-down list, select the scenarios in which you want to send the emails.

  11. Review the summary, and then select Finish.

  12. Monitor the operation progress by selecting Monitor > Jobs.

Perform Clone Lifecycle

Using SnapCenter, you can create clones from a resource group or database. You can either perform on-demand clone or you can schedule recurring clone operations of a resource group or database. If you clone a backup periodically, you can use the clone to develop applications, populate data, or recover data.

Steps

  1. In the left navigation pane, select Resources, and then select the appropriate plug-in from the list.

  2. In the Resources page, select either Database or Resource Group from the View list.

  3. Select the database or resource group.

  4. From the Manage Copies view page, select the backup from primary storage system.

  5. Select the backup, and then select clone icon.

  6. In the Clone Options page, provide all the required details.

  7. In the Location page, select a storage location to create a clone.

    If the SQL Server database ANF volumes are configured in a manual QOS capacity pool, specify the QOS for the cloned volumes.

    If QOS for the cloned volumes is not specified, the QOS of the source volume will be used. If the automatic QOS capacity pool is used, the QOS value specified will be ignored.

  8. In the Script page, enter the script timeout, path, and the arguments of the prescript or postscript that should be run before or after the clone operation, respectively.

  9. In the Schedule page, perform one of the following actions:

    • Select Run now if you want to execute the clone job immediately.

    • Select Configure schedule when you want to determine how frequently the clone operation should occur, when the clone schedule should start, on which day the clone operation should occur, when the schedule should expire, and whether the clones must be deleted after the schedule expires.

  10. In the Notification page, from the Email preference drop-down list, select the scenarios in which you want to send the emails.

  11. Review the summary, and then select Finish.

  12. Monitor the operation progress by selecting Monitor > Jobs.