Manualshelf

White Papers

ManualsBrandsDell ManualsConverged InfrastructureStorage Solution Resources
31323334353637383940
30 TR1081 | Microsoft SQL Server Database Protection Using EqualLogic Auto-Snapshot Manager / Microsoft Edition
The same ASM/ME restore options are available in failover clusters. Any or all of these options can be used
to recover SQL Server data depending on the recovery method needed. Refer to the Restoring SQL Server
Databases with Smart Copies section for more information on the following options.
Mount
Restore selected database
Restore All
Restore as New
7.2.1 Restore All and Restore selected database
In a failover cluster environment, the simplest recovery options are the Restore All or Restore selected
database. These recovery options will perform an “in-place” restore of a SQL Server database from a
Smart Copy. The Restore All option is the fastest recovery method where the original database volumes
are rolled back to the point-in-time of the Smart Copy. The Restore selected database performs a data
movement operation that can take longer depending on the size of the database files being restored.
Both of these restore methods are fully automated and do not require any additional steps by
administrators.
Note: Occasionally during a Smart Copy restore operation on a cluster a “Failed to log off” message will
appear trying to log off of a cluster volume as shown in Figure 16. This may be due to a cluster service
unable to log off the original volume. To continue the Smart Copy restore process make certain the
volume in question should be restored and continue by choosing the “Ignore” button.
Figure 16 Failed to log off message
7.2.2 Restore as New and Mount
The Restore as New and Mount options are useful to recover object level data without a complete restore
of a SQL database. These recovery methods import the Smart Copy onto the cluster nodes but do not
add the disks as cluster resources. Administrators will need to perform additional steps to add the cluster
resources and complete the restore process. This section describes these additional steps needed to
recover SQL data on failover clusters.