x

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?

Thanks

more ▼

asked Jan 27, 2010 at 05:06 AM in Default

bonskijr gravatar image

bonskijr
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, 2010 at 05:52 AM

Steinar gravatar image

Steinar
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, 2010 at 06:32 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.7k 75 79 108

(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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x344
x68
x19

asked: Jan 27, 2010 at 05:06 AM

Seen: 1166 times

Last Updated: Jan 27, 2010 at 05:06 AM