Small business server setup
Hi. I am a small business owner with up to 10 employees and 4 total stores located in different cities. Up until now we have been working locally in each store but we are now about to switch to a different ERP so given the opportunity, I figured we could also sort out the server side of things.
My idea is to get a dedicated server from one of the provides like ovh or hetzner and do the following - setup proxmox with 2 windows server VMs (1 for erp db so that we have one centralized db instead of 4 separate ones and second VM for rdp clients) and 1 VM with nextcloud for storing company files. What I wanted to do is setup local PCs in a way that they log into RDP straight away when turning them on so that every employee works directly on the second VM where ERP's client is located. The reason for that is I want to mitigate PC failures in the stores and also having each employee saving files locally drives me crazy.
I am not a professional by any means, it's just a side project for me and we are going to continue working as we are now until new solution is rock solid so it's not like we are going to have a downtime in our business.
I just wanted to ask for your evaluation if such idea even makes sense. Any advices are highly appreciated! Thanks!