Can SQL Server Express edition be used in Production for small scale business applications?
Did anyone has any experience/exposure on that?
What factors do we need to consider to confirm small scale application (apart from DB size/Memory/Transactions frequency)?
Appreciate your quick responses!!
Many thanks in advance folks!!
Arun
Yes.
Other things to consider:
maintenance. If you want to do anything on a regular schedule, you may have to either run SQLAgent tasks from another database server, or faff about with Windows Scheduled tasks...
reliability / recoverability. What if everything goes wrong and you need to recover a backup? Following on from previous, if you don't have a reliable backup mechanism, you may be faced with rebuilding from scratch. However, how many of your customers will be prepared to lose everything?
Limited to 4 cores, 10GB Database, No TDE etc etc.
https://www.microsoft.com/en-gb/sql-server/sql-server-2017-editions
Microsoft never ever recommend to use Express in production environment. You may use it for your testing environment or as a witness.
SQL server Agent will not be available in Express edition. Hence you cant automate your basic task, you have to rely on different server to schedule things.
19 People are following this question.
