I have a small business with ~15 users who are using a "desktop" style PC as a server. It's running "small business server 2008" and is acting as a file server and a (Microsoft) SQL server. There's no domain controller. The SQL database is just over 8GB and is growing. We've been told there's a 10GB limitation on database size with this edition of SQL server and that we need to switch to standard before the database gets that large.
I'd like to move to Windows Server 2019 and SQL server 2019, but I'm having some difficulty figuring out which editions I need, how many CALs, and which licenses. The likely target hardware is a "server" type machine with two six-core processors.
I've been advised by the company who supplies the software that uses the SQL database that I should run the database on one virtual machine and the file server on a second one. If we do that, there's another desktop PC I'd also like to virtualize and run on the new server (it's access using RDP by a few people).