question

bonskijr avatar image
bonskijr asked

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

sql-serverinstallationserver-instances
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Steinar avatar image
Steinar answered

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

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.