My hosting provider (Rackspace) is offering a fully managed dedicated server with SQL Server Web version () installed. My company handles web development, and has about 20+ clients using ASP.Net + SQL Server 2005.
I am thinking of cutting down costs by installing the free SQL Server 2008 Express instead. I am aware of the 1GB RAM and 4GB/database (is that correct?) limitations. What I would like to know is:
There are a number of limitations, notably:
http://www.dotnetspider.com/tutorials/SqlServer-Tutorial-158.aspx
With regards to the number of databases, this MSDN article says there's no limit:
The 4 GB database size limit applies only to data files and not to log files. However, there are no limits to the number of databases that can be attached to the server.
However, as mentioned in the comments and above, the database size limit was raised to 10GB in 2008 R2 (and is still 10GB as of SQL 2019). Also, this 10GB limit only applies to relational data, and Filestream data does not count towards this limit (http://msdn.microsoft.com/en-us/library/bb895334.aspx).