Administrator Guide

• Expose: The Expose action functions the same in clustered and non‐clustered environments.
However, in a clustered environment, there are additional manual steps required before databases can
be attached from the exposed volumes. To attach a database in a clustered instance of SQL Server,
the database files must reside on clustered disks that the SQL Server instance is dependent on.
Because the disks created by the Expose action are local disks, they must be manually converted to
clustered disks and a dependency on those disks must be added to the SQL Server application before
databases can be attached.
Use Restore to Recover Databases in a Clustered Instance of SQL Server
A clustered instance of SQL Server uses the restore action to recover databases.
NOTE: The new paths must reside on the SQL Server instance’s clustered disks.
Related links
Restore Data to its Original Location
Use Expose to Recover Databases in a Clustered Instance of SQL Server
Expose the restore point containing the databases to be recovered.
1. On the Expose dialog box:
a. Select Make exposed volumes writable.
b. If assigning drive letters, choose drive letters that are available on all nodes of the cluster.
2. Map the exposed volumes to all nodes of the cluster.
NOTE: Ensure that all servers (nodes) of the cluster are added in Storage Center under a cluster
object.
a. Connect to the Storage Center and locate the exposed volumes.
b. Right-click each exposed volume and select Promote Mappings to Server Cluster. The Promote
Mappings to Cluster dialog box appears.
c. Click Promote Now.
d. On each node of the cluster, open the Disk Management utility and verify that all of the exposed
volumes are displayed. If the exposed volumes are not displayed, re‑scan the disks until the
exposed volumes appear. Each node must be able to see all of the exposed volumes.
3. Make sure the Available Storage cluster resource group is on the node that owns the SQL Server
instance.
On a Windows 2008 R2 and 2012 cluster, run the following PowerShell script on the node that owns
the instance to ensure the Available Storage group is on that node:
Import-Module FailoverClusters
$OwnerNode = ( Get-ClusterGroup -Name "Available
Storage" ).OwnerNode.NodeName
$WindowsServerName = ( Get-WmiObject win32_computersystem
).Name
If ( $OwnerNode -ne $WindowsServerName )
{
Move-ClusterGroup -Name "Available Storage" -Node $WindowsServerName
}
4. Add the disks for the exposed volumes to the cluster. Using the Failover Cluster Manager, complete
these actions:
a. Right-click Storage and select Add a disk. The Add Disks to a Cluster dialog box appears.
54