用于生产的 SQL Express? [英] SQL Express for production?

问题描述

在生产环境中使用 SQL Express 是一个合理的选择吗?

Is using SQL Express in a production environment a reasonable choice?

我看了微软的对比图:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

我将在一个中小型网站上使用 SQL Express.我不相信我会超过 4GB 的数据库大小限制.SQL Express 通常在共享托管环境中受支持吗?是否有什么我遗漏的东西会使 SQL Express 成为一个不合理的选择?

I would be using SQL Express with a small to mid-sized web site. I don't believe I would exceed the 4GB database size limit. Is SQL Express typically supported in shared hosting environments? Is there something I'm missing that would make SQL Express an unreasonable choice?

推荐答案

我知道很多人使用 SQL Express 进行生产并且它运行良好，最大的限制因素是缺少用于自动备份的 SQL 代理.要自动备份，您必须获取 VM 映像(如果在 VPS 上)或使用 Windows 调度程序或其他一些技术.

I know many people using SQL Express for production and it works well, the biggest limiting factor is the absence of SQL Agent for automated backups. To automate backups you have to either take a VM image (if on a VPS) or use windows scheduler or some other technology.

唯一的另一个主要限制因素是 ram 限制，但对于一个小型站点，我并没有真正注意到这是一个太大的实际问题.

The only other major limiting factor is the ram limitation, but for a small site I have not really noticed that being too much of an actual issue.

这篇关于用于生产的 SQL Express?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！