Possible Duplicate:
Can you help me with my software licensing question?

If my database is larger than 10GB and I'm using it in READ_ONLY mode, will I be violating the licensing agreement somehow?

It appears that SQL Server Express edition only gets fussy if you try to insert data into a DB larger than the limit, but reading is fine it appears.

In my case, the READ_ONLY DB will be smaller than the limit, but I'm curious to know if this is a 'legal' use of the software (i.e. scaling out reads across lots of static, large DBs served by Express edition)

marked as duplicate by Scott Pack, user9517 Feb 12 '12 at 16:33

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • Closed as duplicate? This is completely unrelated to the linked question on 'licensing in general'. The above question relates only to a potential loop-hole in the licensing of SQL Server Express Edition. – Robin Mar 30 '12 at 14:14

If it's really a read only database and assuming no single table is larger than 10GB, you could break off a few tables to a separate DB and then set up views from one db into the other.

  • That's a very sensible architecture! Though since I've already got a working application this sounds a lot like work to me. It's the licensing that I'd like to know about though: is >10GB READ_ONLY kosher? – Robin Sep 2 '11 at 8:10

Not the answer you're looking for? Browse other questions tagged or ask your own question.