Thanks for the advice, friend! I will try and be sure to write about my results in this subjectI had no problems using Windows 2016 with SQL 2017, last time i set up a Mu Server. Dunno about 2019 but i think you'll be fine.
remember to set up SQL according to Microsoft's Best practices:
DO NOT USE SA ACCOUNT, disable it and create another sysadmin account. Just be sure to update your mu server config files
SE TUP SQL SERVER MEMORY otherwise the sql process WILL use all your RAM: balance it as your SO needs at least 2GB, your muserver exes will requrie some, let sql use 4 or 8 GB depending on the nmber of users. You can change that in options
Set the database in simple recovery mode or your sql logs will be HUGE.
USE MuOnline;
GO
ALTER DATABASE MuOnline
SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE (MuOnline_Log, 1);
GO
ALTER DATABASE MuOnline
SET RECOVERY FULL;
GO
i like the sa change user idea, and now days i recommend 4GB Minimum ram for a mu server (season6 and up), and for higher seasons 8GB (igcn especially s16) in my experience, as you said the more players the more Ram, so that depends on the admin and how his server goes.
and i use this for my logs clearing instead whichworks perfectly fine (manually doing it cuz i like to see the log size time after time)
Code:USE MuOnline; GO ALTER DATABASE MuOnline SET RECOVERY SIMPLE; GO DBCC SHRINKFILE (MuOnline_Log, 1); GO ALTER DATABASE MuOnline SET RECOVERY FULL; GO