July 13, 2009 at 5:57 pm
It would be great if someone can me help me understand exactly why is it recommended to stop SQL Server serivces before installing a service pack.
Thanks much
July 13, 2009 at 9:30 pm
If a file that is being updated by the service pack is in use, a restart will be required. Hence, stop the service and it is unlikely that files affected by the service pack will be in use
July 13, 2009 at 11:02 pm
I have applied service pack to many SQL servers without stopping SQL services , all are successful,just FYI
July 13, 2009 at 11:04 pm
okaticl (7/13/2009)
It would be great if someone can me help me understand exactly why is it recommended to stop SQL Server serivces before installing a service pack.Thanks much
Service pack installer stops the SQL Server (and other affected) services, if they are running. But server reboot is required after completing setup.
If you stop the services before installing a service pack, server reboot is not required.
July 14, 2009 at 6:48 am
Thanks all for helping understand.... Have a good day
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply