4

Like the title says, I just want to verify if we have the need to install a secondary SQL instance on a server that already has one SQL Instance, will the installation of the secondary instance cause an outage on the first?

1
  • Is that actually a good idea, or will these two instances fight over resources and both perform badly? – Simon Richter Mar 2 at 11:03
6

You may require to restart before the install to pass prerequisites or after the install to complete the installation. You should be prepared to reboot the server.

3
  • 3
    Agreed. This is one of those "Do you feel lucky?" moments. :-) – Tibor Karaszi Mar 1 at 15:18
  • 1
    And note that you should always try to reboot after installing software as a test for the next time you reboot. – David Browne - Microsoft Mar 1 at 20:41
  • @DavidBrowne-Microsoft - oh yes! An oft forgotten point! (Oft forgotten by me, anyway ... usually recognized only when it bites me days or weeks later ...) – davidbak Mar 2 at 3:15
2

will the installation of the secondary instance cause an outage on the first?

I interpret your question as will running 2nd instance installation cause outage or affect services of already installed instance. If this is what you are asking then no, it will not but it would be advisable to run any new installation during non production hours. If you are asking about installation popping for restart then yes it may be as Fernando suggested.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.