ebooklub (11/23/2015)
Hi,is anyone tried to run multiple SQL server instances installation at the same time?
Scenario
We need to install 20+ instances of sql2012 + SP on single VM (possibly repeating similar scenario several times few days later) , even if we run unattended installation it will takes few
days to install it
(start install SQL server instance1 ->reboot-> start install SQL Service Pack>reboot .... start install SQL server instance2->reboot... )
Assuming VM has enough CPU and memory can we start installation of 3-4 instances at the same time using unattended install?
From past experience I remember that some times installation of instance or SP would not start because of "reboot pending" ,
is any flag/options could be set bypass this option?
Ideally I would prefer to arrive in morning login to VM start N number of untended installs and continue with other tasks until I have time again (within 3-4 hours) to login
to VM again , reboot window server and start installation of service pack
Thank you
Alex
The windows installer service will only allow a single installation to run at any one time. You could install one machine with all instances and then use as a template
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉