Veeam B&R restore Physical SQL cluster server to ESXi for UAT environment

This lab will use local disk for Quorum not share disk, and just restore 1 cluster hosts let SQL online

Remark: if we want to auto start cluster, we need to restore AD to UAT environment or using a script to start without quorum.

Export disk to VMDK

Our lab don’t need Q: and F:

We can found restored to our ESXi UAT environment

Add A new VM using existing disk

Delete default “Hard disk 1”, and add existing disk just restored.

Our phyical server using EFI bios

Power On windows and we can see the cluster can’t startup

Type below command to startup without Quorum disk

net.exe stop clussvc
net.exe start clussvc /forcequorum

Delete Cluster disk.

If we don’t delete it, we can’t let the disk online in “Disk Management”

Make the SQL data disk online

Reconfig the IP

Click “Start Role” to let SQL Server online

We can see SQL is Running now

But it can’t auto start after reboot server, we need to config Quorum

Delete the old one, because Quorum can’t online in local disk

Create a SMB share

This step need AD to authenticate

Veeam Backup for o365 Account Permission

$UserCredential = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri -Credential $UserCredential -Authentication Basic -AllowRedirection
Import-PSSession $Session -DisableNameChecking

Get-ManagementRoleAssignment -Role “ApplicationImpersonation”
New-ManagementRoleAssignment –Role ApplicationImpersonation –User
Get-ManagementRoleAssignment -Role “ApplicationImpersonation”

Get-ManagementRoleAssignment -Role “View-Only Configuration”
New-ManagementRoleAssignment –Role “View-Only Configuration” –User
Get-ManagementRoleAssignment -Role “View-Only Configuration”

Get-ManagementRoleAssignment -Role “View-Only Recipients”
New-ManagementRoleAssignment –Role “View-Only Recipients” –User
Get-ManagementRoleAssignment -Role “View-Only Recipients”

Get-ManagementRoleAssignment -Role “Mailbox Search”
New-ManagementRoleAssignment –Role “Mailbox Search” –User
Get-ManagementRoleAssignment -Role “Mailbox Search”


Get-ManagementRoleAssignment -RoleAssignee “” -Role “ApplicationImpersonation” -RoleAssigneeType user | Remove-ManagementRoleAssignment

Get-ManagementRoleAssignment -RoleAssignee “” -Role “View-Only Configuration” -RoleAssigneeType user | Remove-ManagementRoleAssignment

Get-ManagementRoleAssignment -RoleAssignee “” -Role “View-Only Recipients” -RoleAssigneeType user | Remove-ManagementRoleAssignment

Get-ManagementRoleAssignment -RoleAssignee “” -Role “Mailbox Search” -RoleAssigneeType user | Remove-ManagementRoleAssignment