March 17, 2011 at 6:23 pm
How long does it take to apply a service pack, for example SP3?
Does it take the same time as installation of sql server or much shorter time?
Thanks
March 17, 2011 at 6:35 pm
It's usually around a 15 minute outage, but I like to set aside a 30 minute window just in case I need to reboot.
You'll definitely want to test/practice the process in a test environment first, so that should give you a good indication of the time needed.
March 18, 2011 at 7:31 am
annasql (3/17/2011)
How long does it take to apply a service pack, for example SP3?Does it take the same time as installation of sql server or much shorter time?
Thanks
It takes around 20-30 minutes if i remember correctly.
As jim suggested, u can check on a test server first and note the process and time both.
Regards,
Sushant
BVI
Regards
Sushant Kumar
MCTS,MCP
March 18, 2011 at 3:07 pm
On Wednesday evening I went from Service Pack 2 to Service Pack 4 in under thirty minutes.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
March 18, 2011 at 9:44 pm
Thank you, does the install need to restart the computer after the installation?
Thanks
March 18, 2011 at 10:33 pm
It depends on what SQL services you have running. The upgrade will inform you of which services are running and which will require a reboot if they are not stopped.
Good luck
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply