installing multipe instances at the same time

  • 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

  • I don't know if you can start multiple installations at the same time, but I do know you can save quite a bit of time by slipstreaming your SP[/url] and/or CU's with the install so you only have to run the installation once. You can even download the media with SP2 already included.

  • Wouldn't it be easier to snapshot the first installation multiple times?

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • the is some restrictions

    no 3-rd party tools

    installation done only as silent untended from bat file

  • ebooklub (11/23/2015)


    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?

    See https://support.microsoft.com/en-us/kb/2008982. Untested by me on SQL Server 2012, and I won't test because I adhere to SQL Server Setup's "recommendations" (requirements), and because my setups are not under the guidance of CSS. I adhere to them because I do not want to see my instances randomly failing in the future (due to my refusal to reboot during a setup).

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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply