Create new named instance of SQL Server

I'm relatively new to SQL Server Administration, although I have used SQL Server databases in my Access and VB applications for years.

I have SQL Server installed in my development environment.  What I think I want to do is create a new named instance on that SQL Server so that when I open the Connect to Server dialog box in SSMS, it has another option "Client X", listed under the Server Names dropdown list.  My goal is to be able to restore a database from a clients computer to my development machine in the Client X named instance?

Am I using the right terminology?

Is this possible?  If so, what are the steps?
LVL 52
Dale FyeOwner, Developing Solutions LLCAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Deepak ChauhanSQL Server DBACommented:
Yes this is possible. You can either restore the backup on existing instance which is already running on the Dev box or you can install another Named Instance.

Steps:
1 . First install the SQL server named instance.
2 . Take a full backup of Client system database.
3. Copy the backupfile to the DEV Box local directory.
4. Connect the Named instance on Dev Box.
5. Restore the Database using backupfile.
Dale FyeOwner, Developing Solutions LLCAuthor Commented:
The piece I'm missing is #1, how to install the new named instance, I've done all of the other stuff before.
Deepak ChauhanSQL Server DBACommented:
No much difference between installation of Default installation and Named instance installtion almost similar. You have just check the "Named Instance" radio button and put the instance name "Client X" (in your case) on the installation page.

This is the link for installation screenshot for reference. This is for SQL server 2008 R2.

http://www.sqlcoffee.com/sqlserver2008_0013.htm

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dale FyeOwner, Developing Solutions LLCAuthor Commented:
Thanks, just what I needed.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.