Access vs Comercially available databases

[Isaac]

"Unlimited" if SQL Server edition is not Express, and running on Windows Server.

Well yes, definitely the business is not expected to be running a trial version of ... anything

 

[BlueSpruce]

Well yes, definitely the business is not expected to be running a trial version of ... anything

SS Express is not a trial version. Some of our customers have been using it since year 2016 with the following server config we put together for them for under $5K. The servers run Linux with multiple KVM's. For the past 9 years, none of these customers have experienced any hardware issues. These servers have on_board, battery backed, hardware based RAID 10 controllers.

 

[BlueSpruce]

I was under the impression that SS Express was not for production use. I know that lots of small companies use it that way. It is limited in what it supports as well as how much data you can hold.

Express has artificial limits, such as available memory, cpu cores, and db size (10GB), but it performs well for up to 8 workstations running Access FE's.

https://learn.microsoft.com/en-us/s...ents-of-sql-server-2022?view=sql-server-ver17

 

[AHeyne]

It should be mentioned that SQL Express does not include SQL Server Agent. You have to script database maintenance and backup yourself. That's a disadvantage in a professional environment.

 

[GPGeorge]

It should be mentioned that SQL Express does not include SQL Server Agent. You have to script database maintenance and backup yourself. That's a disadvantage in a professional environment.

True, but there are other backup solutions available, both free and paid.

For example, here are two selected at random, with no recommendation implied:

Free SQL Server Express Scheduled Backup Utility

Free SQL Server Express Scheduled Backup Utility

www.sqlbackupmaster.com

SQLBackupAndFTP - SQL Server, MySQL and PostgreSQL Backups

SQL Server, MySQL and PostgreSQL Backups made easy with SQLBackupAndFTP. All Backup types, Encryption, Compression, Scheduling, Email notifications, Sending to Folder, FTP or Cloud

sqlbackupandftp.com

 

[BlueSpruce]

True, but there are other backup solutions available, both free and paid.

For example, here are two selected at random, with no recommendation implied:

Free SQL Server Express Scheduled Backup Utility

Free SQL Server Express Scheduled Backup Utility

www.sqlbackupmaster.com

SQLBackupAndFTP - SQL Server, MySQL and PostgreSQL Backups

SQL Server, MySQL and PostgreSQL Backups made easy with SQLBackupAndFTP. All Backup types, Encryption, Compression, Scheduling, Email notifications, Sending to Folder, FTP or Cloud

sqlbackupandftp.com

I was just about to reply similarly. Not having the agent is not an issue.

 

[Isaac]

SS Express is not a trial version. Some of our customers have been using it since year 2016 with the following server config we put together for them for under $5K. The servers run Linux with multiple KVM's. For the past 9 years, none of these customers have experienced any hardware issues. These servers have on_board, battery backed, hardware based RAID 10 controllers.

View attachment 121430

It's basically a trial version , in that any serious business is not expected to be running it - although I'm fully aware that you can, and I have, too.