May 24, 2011 at 12:56 pm
Easiest question of the day...
After installing a service pack updates I am told that a restart of the server is required to complete the installation.
At this point can I Restart the MSSQLSERVER in configuration manager or do I actually need to perform a START > Shutdown > Restart of the physical box?
May 24, 2011 at 1:01 pm
A restart of services are required after installing a Service Pack or a Cumulative Update and it is a good practice to reboot the server after installing a Service Pack or a Cumulative Update.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 24, 2011 at 10:32 pm
Vertigo44 (5/24/2011)
Easiest question of the day...After installing a service pack updates I am told that a restart of the server is required to complete the installation.
At this point can I Restart the MSSQLSERVER in configuration manager or do I actually need to perform a START > Shutdown > Restart of the physical box?
First thing first, when you are asked by the installation to restart the server , it is actually talking about your physical Server not just your sql server service or else.
Sql server services are automatically restarted a few times during the installation itself. So, you don't need to restart your sql server services after the installation. But what you actually require is to restart your physical server to take the installation into Affect.
Regards,
Sachin
May 25, 2011 at 8:12 am
SP4 doesn't seem to require a reboot or manual restart of services. (Recently installed on test server). However, I'll probably be doing reboots on the production boxes - just in case.
May 25, 2011 at 10:01 am
A reboot will not be required if you don't have any of the affected SQL Services running - a list will be provided during the Service Pack installation process. However, it is always good practice to reboot after the application of any Service Pack.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
May 25, 2011 at 10:38 am
Got it. Thanks guys!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply