Faster way to add a sql server instance

I find it rather a hassle that in order to have another instance you have to install Sql Server(again) when in fact it's just creates another folder, create another entry in the services(I might be oversimplifying this).

Do you know of a more quicker way to add another sql server instance?


more ▼

asked Jan 27 '10 at 05:06 AM in Default

bonskijr gravatar image

204 5 5 7

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

What you can do is to script an installation. (when you install SQL 2008 a script called configuration.ini I believe is created automatically) Call setup using that script, and it will install pretty quick. Of course you have to edit the script so that you install a named instance. More info can be found in Books Online

more ▼

answered Jan 27 '10 at 05:52 AM

Steinar gravatar image

1.7k 3 4 6

(comments are locked)
10|1200 characters needed characters left

I think there is a whole lot going on that you dont see during the install. SQL Server isnt just the storage area you see on the hard drives. As a parallel, you couldnt copy iTunes installation to a different folder and run two iTunes applications ...

As Steinar says, try the scripting option if you want to speed the process up.

more ▼

answered Jan 27 '10 at 06:32 AM

Fatherjack gravatar image

Fatherjack ♦♦
41.2k 72 77 107

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 27 '10 at 05:06 AM

Seen: 968 times

Last Updated: Jan 27 '10 at 05:06 AM