asked on

Combining multiple application database into SQL Express Edition

People,

I'd like to install multiple application into single server but some of the applications has its own SQL Server database requirement.

So like the following:

Scenario #1
App1 - SERVER-VM\SQLDB1
App2 - SERVER-VM\SQLDB2
...
Appn - SERVER-VM\SQLDBn

assuming those application can use SQL Server 2012 Express Edition, can I just install SQL Express Edition and then set multiple DB instances for all of those apps above ?

Or is it better just to deploy it using single SQLDB Instance and then just install multiple DB under the default SQLEXPRESS instance ?

ASKER CERTIFIED SOLUTION

Deepak Chauhan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Mohammed Khawaja

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Albert Widjaja

ASKER

ok, so if I install multiple instances of SQL Express Edition is that going to be working under one same server ?

suppose I got 8 GB of RAM, so the maximum that I can install the SQL Express is 4 isntances, assuming 4 GB goes to the OS. is that correct ?

SOLUTION

Mohammed Khawaja

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Albert Widjaja

ASKER

Thanks !