November 23, 2015 at 12:32 pm
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
November 23, 2015 at 1:20 pm
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.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 23, 2015 at 1:29 pm
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/
November 23, 2015 at 3:41 pm
the is some restrictions
no 3-rd party tools
installation done only as silent untended from bat file
November 23, 2015 at 10:24 pm
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).
November 24, 2015 at 7:42 am
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