Add Express instance

Question

Add Express instance

adonetok

SSCrazy Eights

Points: 8395
More actions
December 11, 2012 at 7:00 am

#271410

I installed SQL 2008 R2 in local pc.
Can I add "SQLEXPRESS" instance in it so that I do not need to install SQL Express edition?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113509 More actions · Answer 1

So you have already installed SQL?

You want to add a new instance of SQL called SQLEXPRESS or do you want your existing install to be called a named instance of SQLEXPRESS?

adonetok SSCrazy Eights Points: 8395 More actions · Answer 2

So you have already installed SQL?

Yes, I already installed SQL. The name is MYPC

You want to add a new instance of SQL called SQLEXPRESS or do you want your existing install to be called a named instance of SQLEXPRESS?

I want to add another instance calling it as MYPC\SQLEXPRESS

Lowell SSC Guru Points: 323518 More actions · Answer 3

the better question is do you REALLY need to install another instance in the first place, if you already have SQL installed?

Having a single instance provides a single centralized point so you can do maintenance and everything else, and you would not need to divide the memory on the machine between three or more items (Operating System, Default instance, Express instance)

unless you have a specific need, i don't see any benefit.

* now having said that, I have the last 4 SQL versions installed on my development machine, 2005/2008/2008R2/2012, but that's due to customer support and testing reasons, not because I want separate instances for some biz reason or anything. I actually only use one on a daily basis unless I need to restore a database that is a different /lower version.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!