I'm developing a web site and i would like to use the SQL Server Express as my DB. The Express edition is limited for 4GB per DB.
Is it legal to create & use several DB's for the use of a single web site?
A:
I don't see why not, based on Microsoft's feature and limitations page: SQL Server Editions
The hard limitations, per that link, of the Express Edition, are:
SQL Server Express supports 1 physical processor, 1 GB memory, and 10 GB storage
Michael Goldshteyn
2010-10-31 12:48:10
thanks, but just to be clear i meant the use of full 4GB on each DB.
Jin
2010-10-31 12:57:41
meaning that i'll have 16 GB total for 4 DB's on a single site.
Jin
2010-10-31 12:59:20
The limitation is 10GB, not 4GB, as you will see if you read the link that Michael Goldshteyn posted.
dportas
2010-10-31 18:16:35
+3
A:
Hello,
What about trying to migrate SQL Server Express 2008 R2 who allow 10GB per DB ?
G. Qyy
2010-10-31 13:01:03
A:
thanks, but just to be clear i meant the use of full 4GB on each DB.
meaning that i'll have 16 GB total for 4 Full DB's on a single site.
Is there any knowledge on the legal aspect of that kind o usage?
Jin
2010-10-31 14:10:03
A:
I suggest you read the licence agreement and satisfy yourself about how the product can be used. Note that the actual limit in SQL Server Express 2008 R2 is 10GB, not 4GB.
However, you should seriously consider whether Express is the right choice for this application. Splitting the data into four databases will still leave you restricted to only 1GB RAM. That's a significant scalability limitation for web site usage.
dportas
2010-10-31 18:15:27