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
Answer by ThomasRushton ·
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
Answer by Elysian ·
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.