White Papers

Additional resources
21 Dell EMC SC Series: Disaster Recovery for Microsoft SQL Server Using VMware Site Recovery Manager | CML1018
}
# Reset the volume
Set-CMLDiskDevice -SerialNumber $DiskSerialNumber -ReadOnly:$False
Set-CMLDiskDevice -SerialNumber $DiskSerialNumber -ResetSnapshotInfo
Set-CMLDiskDevice -SerialNumber $DiskSerialNumber -Online
Once all of the database volumes have been cleaned up and brought online, start the SQL Server service as
well as any other services used with SQL Server (like the SQL Server Agent).
For automated recovery, configure the recovery plan to power the virtual machine on. Create a recovery step
to run the following PowerShell cmdlets after the virtual machine is powered on:
# Assign Variables
$SQLServerServiceName = "MSSQLSERVER"
$SQLAgentServiceName = "SQLSERVERAGENT"
# Load the Storage Center PowerShell Command Set
If (!( Get-PSSnapin | Where-Object { $_.Name -eq
"Compellent.StorageCenter.PSSnapin" } ))
{
Add-PSSnapin -Name "Compellent.StorageCenter.PSSnapin" | Out-Null
}
# Get all offline disks (assumes offline disks are pRDMs recovered from VSS
snapshots)
$DiskArray = Get-CMLDiskDevice | Where-Object { $_.Status -eq "Offline" }
# Reset each disk
ForEach ( $Disk in $DiskArray )
{
Set-CMLDiskDevice -SerialNumber $Disk.SerialNumber -ReadOnly:$False
Set-CMLDiskDevice -SerialNumber $Disk.SerialNumber -ResetSnapshotInfo
Set-CMLDiskDevice -SerialNumber $Disk.SerialNumber -Online
}
# Start SQL Server services
Start-Service -Name $SQLServerServiceName
Start-Service -Name $SQLAgentServiceName
Note: This is an example of the PowerShell commands required to recover pRDMs from snapshots created
by Replay Manager. This is not a production-ready script.