Users Guide

Table Of Contents
The Select Databases dialog box opens.
2. Select one or more of the databases listed in the top panel. Click Next.
The Restore Database dialog box opens.
3. Select from the following options:
Apply LogsEnables you to perform custom restore operations without recovery such as manually applying the database
transaction logs to the restored database.
Fully RecoverCompletely restores the database to the contents represented by the Smart Copy set. You can fully
recover a database regardless of the Backup Type used when the Smart Copy set was created.
4. Click Restore.
If the SQL Server is clustered, the cluster physical disk resource for the volume containing the database to be restored is
placed in maintenance mode until the restore operation completes.
When the operation completes, ASM/ME displays the following message:
Restore completed successfully.
Restore All Databases
If a Smart Copy Set contains copies of several databases, you can restore all databases in a single operation.
1. Under the Smart Copies node, right-click the relevant Smart Copy and select Restore All.
ASM/ME displays its progress for steps such as setting volumes offline and later, back online. If the SQL Server is clustered,
the cluster physical disk resources for the volumes are placed in maintenance mode until the restore completes.
2. Wait until ASM/ME displays the following message:
Database restored. Refresh the database management GUI to see the restored database.
Restore a Database as New
Before you begin, make sure the ASM agent is configured to run as a user who has permissions to perform this operation in
SQL.
For detailed information about the various options for this procedure, see the information in the following table.
To perform Restore as New operations on alternate SQL Server hosts, see Importing a Smart Copy.
Table 28. Data Required for Restore As New
Item Description
Smart Copy Type
Restore as New Select option for a snapshot or clone Smart Copy set.
Clone and Restore as New Select option for a replica Smart Copy set.
Volume Mapping
Drive Letter Drive letter, NTFS folder mount point or ReFS folder mount point for the new
volume.
Restore as New Database
New Database Name If required, modify the new database name. ASM/ME appends the string _new to
the original database name to ensure that it is not confused with the original.
Database Server to use
Specify the name of an SQL Server instance that serves the new database, if
different from the instance serving the original database.
On a cluster, this name is the network name of the clustered SQL Server. The
current node must be the owner of the SQL Server Resource Group.
If you are restoring to a new SQL instance, then the SQL Server instance should be
the same SQL version as the original instance.
82 Using ASM/ME with SQL Server