question

arunobti avatar image
arunobti asked

SQL Express edition for production use

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

sql-server-2012sql-server-2014sql-server-express
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered

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?

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·

Limited to 4 cores, 10GB Database, No TDE etc etc.

https://www.microsoft.com/en-gb/sql-server/sql-server-2017-editions

1 Like 1 ·
Elysian avatar image
Elysian answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.