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

MsSQL dbname(Suspect)

EXEC sp_resetstatus dbname;
ALTER DATABASE dbname SET EMERGENCY;

DBCC checkdb(‘dbname’);
ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DBCC CheckDB (‘dbname’, REPAIR_ALLOW_DATA_LOSS);
ALTER DATABASE dbname SET MULTI_USER;

WSUS update error

win2012
80244010 wsus server busy, keep retry
80244019 rename SoftwareDistribution

win2008 R2
80092004 missing KB4474419 KB4490628
80243004 let windows update icon visable

SQL check client IP

select

conns.client_net_address, conns.auth_scheme, sess.* from sys.dm_exec_sessions sess

LEFT OUTER JOIN sys.dm_exec_connections conns on sess.session_id = conns.session_id

exec sp_who2

Bind mail control

SPF

    1. IN TXT “v=spf1 ip4:123.123.123.1 ip4:123.123.123.2 -all”

DMARC
_dmarc IN TXT “v=DMARC1;p=quarantine;rua=mailto:rua@abc.com;ruf=mailto:ruf@abc.com”

DKIM
F4EEC778-4C21-11EA-AD84-83DCF040F65E._domainkey IN TXT ( “v=DKIM1; k=rsa; ”
“p=MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCxICrPoI8+AZ85ney0JRnniswBUCeJSCCmV6eWgxotF7ncQdWLFvNadR5gQiWJi0EHnarsVez6ET+jL9IoHgV6QSyUwBraOKPlU+XzlZVUGUnAn1BdsS6LjdT0anJlu07RiLdgfIJL0zufhEsHVSx3EwWrWL3NQlcLIVi0rCThjwIDAQDB” )