Home / server / Questions / 307262
In Process
Robin
Asked: 2011-09-02 06:57:58 +0800 CST

Exceeding the DB size limit on SQL Server Express in READ_ONLY [duplicate]

  • 772

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)

licensing sql-server-express sql-server-2008-r2

1 Answers

  1. 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.

    • 2