• 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" 😉