I have a query, we are using ACT premium 19.2 version for 30 users and using SQL Express version which is gone high till 9 GB approx. in size. So we are trying to purchase SQLSvrStd 2017 SNGL OLP NL. So, we need to confirm will this version fine for our 30 users and handle huge database?
Anyone who knows abt this would be a real help.
Take a look at the system requirements in the act! knowledge base for your act version, please. https://help.act.com/hc/en-us/articles/360024255514-What-are-the-system-requirements-for-Act-
Thursday - last edited Thursday
Yes to going to SQL standard edition but do consult the matrix in the above reply for which version is compatible with your version of ACT.
The big benefit is that SQL Express is restricted to a 10GB limit but standard is unrestricted and is also able to use more resources so better for multi user installations.
You will need this information to help you manually create the ACT SQL instance