Administrator Guide

Related concepts
Advanced Recovery Scenarios for SQL Server on page 42
Related tasks
Expose a Restore Point (Windows Extensions Only) on page 38
Expose a Restore Point Stored on an SMB File Share on page 39
Use a Replay to Manually Recover a Database
Dell recommends using Replay Manager to manage Replays. However, databases can be recovered using Storage Center rather than
Replay Manager during disaster recovery. This manual process provides the same functionality as the Expose action in Replay Manager.
1. Create a view volume on the desired Replay for each database volume and map it to the database server. Make sure all Replays are
from the same restore point. For each database volume, do the following:
a. In the Storage Center, right-click the desired Replay and select Create Volume from Replay. The Create Volume from Replay
dialog box opens.
b. Select the folder for the view volume.
c. Set the name for the view volume.
d. Click Create Now. The Map Volume to Server dialog box opens.
e. Select the server to which the view volume should be mapped.
f. Click Continue.
g. Click Create Now.
2. On the database server, bring the disks for the new view volumes online and assign a drive letter or NTFS mount point.
a. Open Server Manager and select Disk Management.
b. Verify all disks for the new view volumes are displayed. If any disks are not displayed, re-scan the disks until they appear. To re-
scan the disks, right-click Disk Management and select Rescan Disks.
c. Bring each new disk online. To bring a disk online, right-click the box containing the disk number and select Online.
d. Assign a drive letter or mount point to each new disk. Right-click the partition and select Change Drive Letter and Paths. The
Change Drive Letter and Paths dialog box opens.
e. Click Add. The Add Drive Letter or Path dialog box opens.
f. Select an available drive letter or mount point and click OK.
3. On the database server, clear the VSS attributes from each volume.
a. Open a Command Prompt window.
b. Start the disk part utility by typing diskpart and pressing Enter.
c. For each volume, type the following commands, pressing Enter after each command.
NOTE: To see a list of all available volumes, type: list vol
Select the volume using the volume number or drive letter with one of the following commands:
select vol number
select vol letter :
Clear the read-only attribute:
attrib vol
clear readonly
Clear the hidden attribute:
attrib vol clear hidden
Clear the shadow copy attribute:
attrib vol clear shadowcopy
Backing Up and Restoring Data
45