Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT premium 9.2 SQL database issue

Tuned Listener
Posts: 66
Country: India

ACT premium 9.2 SQL database issue

Hi

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.

 

Regards, 

Aasif

Copper Elite Contributor
Posts: 97
Country: Germany

Re: ACT premium 9.2 SQL database issue

Swiftpage officially recommends using SQL Standard instead of Express for above 5 GB and/or 20 Users.

 

Jan Teske
ACC
jbt consulting
Highlighted
Tuned Listener
Posts: 66
Country: India

Re: ACT premium 9.2 SQL database issue

Thank you for your quick reply..

so, can we go for SQLSvrStd 2017 SNGL OLP NL version for 30 user of ACT?

 

Regards, 

Aasif

Copper Elite Contributor
Posts: 97
Country: Germany

Re: ACT premium 9.2 SQL database issue

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-

Jan Teske
ACC
jbt consulting
Silver Contributor
Posts: 1,779
Country: United_Kingdom

Re: ACT premium 9.2 SQL database issue

[ Edited ]

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

 

https://help.act.com/hc/en-us/articles/360024255554  

Platinum Elite Contributor
Posts: 14,584
Country: Australia

Re: ACT premium 9.2 SQL database issue

For what it's worth, I've been running Act! 21.1 on SQL 2017 Standard ... I doubt if v19 of Act! would be ok, though