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?
asked Jan 27, 2010 at 05:06 AM in Default
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
answered Jan 27, 2010 at 05:52 AM
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.
answered Jan 27, 2010 at 06:32 AM