I need to install SQL server 2005 sp3. I need to know before if the installation need a reboot and if the installation will stop my SQL service. I got over 300 database on my server.
thanks.
A:
Yes. The install of SP3 will require a reboot (at least it always has in the 10 or so I've done).
Ed Harper
2009-10-15 13:50:38
+2
A:
Whether or not, a reboot is required, it would seem prudent to manage the risk involved by scheduling a down window, just in case something unexpected happens during the install.
If you are talking about a mission-critical production server, I'd want to have any worse case scenarios catered for.
Mitch Wheat
2009-10-15 13:51:01