5

We have an existing sql server 2012 instance but without full text search. before I add the feature, I want to know if it stops or restart the instance since it is for production.

thanks in advance.

2 Answers 2

2

The setup program restarts the target instance when installing full text search.

However, there's an easy way to find out: test it! Don't trust what I say: test it in your test environment.

2
  • thank you for the reply. In test it is already installed where needed and was done by someone else. if not, I would have tested and done it first in test.
    – JoeriDC
    Commented Mar 12, 2015 at 7:16
  • I did the test: the instance is automatically restarted during the feature installation (without any notification)
    – mistika
    Commented Apr 13, 2018 at 12:05
1

For anyone wondering about this, I've just tried it with SQL Server 2016.

It doesn't restart the service in a normal sense of the term. All the connection are like frozen or delayed for a few seconds (around 20 seconds in my case) and then the response is returned. That means that you won't get any errors in the application (maybe a timeout or something like that), but the applications might take a bit to respond.

Also, if you have SSMS open and connected for example, the connection is not dropped, it continues working without having to reconnect or resetting to the default database.

The only thing I've noticed though, the SQL Server Agent was not started automatically. It was set as Startup: Automatic, but after the install it was stopped and I had to manually start it again.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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