Install multiple instance of database to one computer question

Dear all,
If i want to install multiple instance of database to one computer(XP) for a
developer edition. Do i need to buy two license of developer edition for two
instance to install to one computer? Moreover if i install two instance to
one computer, can the two instance of database can start together in
enterprise manager/ or just one instance can operate in one time? It is
because install two instance of database, one for on-going development and
one for use to backup the data from the production server(since it need to
test the backup data can restore)I don't know about the license but you can run 2 instances ( 1 has to be
named) at the same time just register them both in enterprise Manager
http://sqlservercode.blogspot.com/
"Joe" wrote:
> Dear all,
> If i want to install multiple instance of database to one computer(XP) for a
> developer edition. Do i need to buy two license of developer edition for two
> instance to install to one computer? Moreover if i install two instance to
> one computer, can the two instance of database can start together in
> enterprise manager/ or just one instance can operate in one time? It is
> because install two instance of database, one for on-going development and
> one for use to backup the data from the production server(since it need to
> test the backup data can restore)|||"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:4B562ABF-916B-4EDD-A145-E79D773C7B91@.microsoft.com...
> Dear all,
> If i want to install multiple instance of database to one computer(XP) for
> a
> developer edition. Do i need to buy two license of developer edition for
> two
> instance to install to one computer? Moreover if i install two instance to
> one computer, can the two instance of database can start together in
> enterprise manager/ or just one instance can operate in one time? It is
> because install two instance of database, one for on-going development and
> one for use to backup the data from the production server(since it need to
> test the backup data can restore)
My understanding is that you can install as many instances as you want on
the same machine. The licensing comes in to play either per processor or
per seat. With the developer edition, I don't think you need to purchase
CALs as you are not supposed to be using Dev edition for production. I
would double check that however.
There is no problem installing multiple instances on the same server and
both will be able to run concurrently. It will eat up more of your
resources however as each instance of SQL Server will have it's own services
executing and memory needs.
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||Yeah and the developer edition is only like $50 a copy.
See:
http://www.microsoft.com/sql/howtobuy/faq.mspx
and
http://www.microsoft.com/sql/howtobuy/default.mspx
and
http://www.microsoft.com/sql/howtobuy/development.mspx
HTH
Jerry
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:%23Dr8ldPxFHA.596@.TK2MSFTNGP12.phx.gbl...
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:4B562ABF-916B-4EDD-A145-E79D773C7B91@.microsoft.com...
>> Dear all,
>> If i want to install multiple instance of database to one computer(XP)
>> for a
>> developer edition. Do i need to buy two license of developer edition for
>> two
>> instance to install to one computer? Moreover if i install two instance
>> to
>> one computer, can the two instance of database can start together in
>> enterprise manager/ or just one instance can operate in one time? It is
>> because install two instance of database, one for on-going development
>> and
>> one for use to backup the data from the production server(since it need
>> to
>> test the backup data can restore)
> My understanding is that you can install as many instances as you want on
> the same machine. The licensing comes in to play either per processor or
> per seat. With the developer edition, I don't think you need to purchase
> CALs as you are not supposed to be using Dev edition for production. I
> would double check that however.
> There is no problem installing multiple instances on the same server and
> both will be able to run concurrently. It will eat up more of your
> resources however as each instance of SQL Server will have it's own
> services executing and memory needs.
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>