Hi all, interesting little challenge this one.
My wife works for a very small company, and like most small businesses they have taken a significant hit in cash flow during COVID.
That being said they have hung in there and are building a strong base once more.
Before lock down my enterprise donated two HP servers to the business, these were already very long in the tooth, but better than the desktops they were running for business applications etc
Both are gold Xeon duel builds one has 128gb memory and is SAS driven, the other has only 16gb memory and is 3.5" SATA.
The 128gb server I have running HyperV with …
AD domain controller / DNS / DHCP VM
SQL Server 2016 VM with their CRM and SAGE DBs
Windows 11 VM for shared access to the SQL Srv
The 16gb server just a file server. Plain and simple
They also have two Synologys
RS820+ running Active backup and C2 off-site
RS1619xs+ with 40TB Raid5 and 32gb mem doing nothing.
The challenge is that both the HP servers are dying, mostly the HyperV. 4 disk failures in the last 2 months and memory bank failures too.
This is my plan, and I’d like some help in planning what order to proceed.
Use the RS1619xs+ as the main file server, and run directory server, DNS and DHCP there. Also to run the Windows 11 VM for shared access to the SQL server.
Use the file server with the remaining good memory installed to build a physical SQL Server instance and put the databases on that.
Use the RS820+ as a secondary domain, DNS and DHCP server, keeping is function as the backup system local and off site.
Is this the way to go? I’ve never moved a SQL database before, my assumption is follow the guidelines off back it all up and restore the data to the physical box. As I have a full VM backup and a full data backup. Is it possible to restore the VM to a physical box and just have windows deal with the drivers changes etc? Could it be that easy?
Any input would be great. Thanks in advance