Cloning databases using SnapManager

In the SnapManager console root, select a server.

In the Actions pane, click Clone Wizard.

In the Start page, click Next.

In the Clone Type page, select Clone Databases from existing Backup Set and click Next.

In the Backup Selection page, double-click the backup from which you want to create the clone and then click Next.

For more information about these options, see Types of SnapManager restore operations.

SnapManager displays the list of databases to be cloned. By default, SnapManager provides the same name to the clone as the original database. You should rename the cloned database. Click Next.

In the Restore Settings page, specify the clone database name and click Next.

In the Clone to Server page, specify the clone server name, choose whether you will use a letter drive or a mount point, and click Next.

If you choose a mount point, specify the mount point directory or accept the default.

If you specify a mount point, make sure the directory is empty. If there is a database in the directory, after the mount the database will be in an invalid state.

For more information about mount point settings, see Database integrity verification options

• Update SnapMirror after the clone operation completes.
• Archive the clone to a SnapVault backup.
• Clone from a SnapVault backup.

In the Clone Life Cycle Management page, you can choose to resynchronize the clone and to automatically delete the clone.

For more information about these options, see Understanding cloned database lifecycles.

In the Restore Settings page, select the state of the database you want after restore and click Next.

If you select "Leave the database in read-only mode and available for restoring additional transaction logs, the "Undo file directory" option activates.

If you want to run a command or script prior to performing the clone operation or after the clone operation finishes, select the "Run Command Settings" option and click Next.

Result If you select this option, SnapManager displays the Run Command dialog box. For more information, see Pre-command and post-command script settings.

Click Finish.

Result The Clone Status window is displayed that shows the Clone task list and the Clone Report.

Click Start Now to start cloning.

The operation is performed, and each item in the Clone Task List is checked off as the task is complete. A message appears indicating the successful completion of the cloning operation.

In the SnapManager console root, select a server.

In the Actions pane, click Clone Wizard.

In the Start page, click Next.

In the Clone Type page, select Clone Active Production Datbases and click Next.

In the Database Selection page, double-click the backup from which you want to create the clone and then click Next.

Continue with the next steps, as instructed in the wizard.

If you want to rename the new database clone's paths based on the name of the new database, select the appropriate check box in the wizard.

To perform a clone on a SnapMirror destination volume, select the "Clone on available SnapMirror destination volumes" check box.

If you want to run a command or script prior to performing the clone operation or after the clone operation finishes, select the "Run Command Settings" option.

Result: If you select this option, SnapManager displays the Run Command dialog box. For more information, see Pre-command and post-command script settings.

The wizard takes you to the final option that displays the SnapManager clone task list. Click Start Now to begin the specified tasks.

Result: The operation is performed, and each item in the Clone Task List is checked off as the task is complete. A message appears indicating the successful completion of the cloning operation.

Review the list in Understanding SnapManager Restore.

Ensure that all Windows Explorer windows are closed on the SQL Server computer that is running SnapManager.

Disable any SnapManager operations that are scheduled to run against the SQL Server data you are restoring, including any jobs scheduled on remote management or remote verification servers.

In the SnapManager console root, click the SQL Server you want to perform the restore operation on.

In the Scope pane, click Restore.

Result It enables you to navigate the backup sets.

In the Results pane, double-click to select the backup set that you want to clone.

In the Actions pane, click Clone.

Result The SnapManager for SQL Server-Clone window appears.

If you want to clone a database on a server other than the original server, follow these steps:

1. Click the "..." button next to "Clone to Server (Instance)."
2. The "Select SQL Server Agent" dialog box appears.
3. Select the SQL Server to which you want to restore the database.
4. Choose the Connection by selecting the "Use Windows Authentication" or "Use SQL Server Authentication" option.
5. Click OK to apply your change and close the dialog box.

If you want to clone a database with a different name, follow these steps:

1. Click the option marked "..." next to "Clone as Database."

   The "Individual Database Restore As..." dialog box appears.

2. In the Restore as Database box, enter the database name to which you want the backup restored. This database name must not already exist on the SQL Server instance to which you will be restoring the database.
3. Click OK to apply your change and close the dialog box.

You want to restore to a point-in-time backup

1. Click the tab marked "..." next to "Point-in-Time Restore"

   The Point-in-Time Restore dialog box opens.

2. In the Point-in-Time Restore dialog box, specify the date and time after which transaction logs are not applied to the restored database.
3. Click OK to apply your change and close the dialog box.

You want to restore to a marked transaction

1. Click the tab marked "..." next to "Marked Transaction."

   The Marked Transaction dialog box opens.

2. In the Marked Transaction dialog box, select which marked transaction at which to stop the restore operation.
3. Click OK.

To start the clone operation, click Clone.

Result SnapManager begins to clone your databases from the backup you selected. SnapManager Clone completes each task and checks it off the list shown in the Restore Task List view.

You can switch back and forth between the task check-off list and the progress report using the Switch buttons on either window.

If the clone is successful, the Task window shows the check-off list with the tasks completed, and a dialog box reports that the restore was successful.

After all the restore tasks are finished, click OK.

Result Your restore is complete and your SQL Server computer comes back online.

If you have not already done so, start SnapManager for SQL Server by accessing the Windows Start menu, and selecting Program Files > NetApp > SnapManager for SQL Server.

Result: The SnapManager for SQL Server console appears.

In the Scope pane, double-click SnapManager for SQL Server.

Result: SnapManager displays the SQL Server database servers running.

Click the SQL Server database server that you want to configure.

Result: SnapManager displays the Status dashboard in the Result pane.

In the Actions pane, click Clone Wizard.

Result: The Clone wizard launches and the Welcome window appears.

Click Next.

Result: SnapManager displays an option for selecting the operation that you want to perform.

Select the operation you want to perform, and click Next.

Result: SnapManager displays the Database to clone window listing the available cloned databases. Select the cloned databases that you want to delete.

In the Delete clone summary screen, verify the settings selected in the previous steps and click Finish.

This takes you to the final option that displays the Delete clone task list. Click start now to begin the specified tasks.

Result: The operation is performed, and each item in the Clone Task List is checked off as the task is complete. A message appears indicating the successful completion of the delete clone operation.

Click Close to close the Clone Status dialog box.