Andrew Harry Andrew Harry - 10 months ago 51
SQL Question

Limitations of Running Multiple Instances of MS SQL EXPRESS

I plan on installing Multiple Instances of MS SQL EXPRESS on my Development Server.

I am hoping this will let me get around the limitations of SQL EXPRESS:


  • 1 GB of RAM,

  • 1 CPU

  • Database size max 4 GB



[I understand and wish that I could afford a full licence version of SQL Server.]

So, would this work? Would each instance have their own independent limitations?

Answer Source

If you have an MSDN subscription then you can install the Development version and I don't believe that has any restrictions...of course it's for development purposes only.

You can purchase SQL Server Developer Edition from Microsoft at this link...it's $50

http://store.microsoft.com/microsoft/SQL-Server-2008-Developer-Edition/product/C5EA00C9?WT.mc_id=productinfocenter


As of 2016 (?) SQL Server Developer Edition is Free, downloadable at microsoft.com/sqlserver.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download