Updating from sp2 to sp3
And where do I find the right files, that don't require an internet connection during installation?
You might also make a slipstream install CD, which has SP3 integrated into the install CD.
Visit Stack Exchange Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Sign up to join this community I have to install the Service Pack 3 on an SQL instance running with the SP1. It doesn't happen all the time, but sometimes a SP ends up breaking something and that then gets fixed in a later CU.
No test, the install is directly on the production server. In your case you are going with a fairly late release because Microsoft hasn't been generally releasing CUs - only security updates for that product with the current release now 3 versions higher.
During the installation proccess at the end you could receive an error with pending reboot.
You first have to reboot your SQL Server then you can install SP3.
Or will it wait until the TIME the Automatic Updates are set to ... I would have thought an Update to SP3 would supersede that time and start happening immediately.You only need to reboot once, after the update is completed.It is still possible to update with the following alternatives: Make sure the currently installed version has the latest patches installed.The computers don't have an internet connection (only a small intranet) and have never been updated since first install.Do I need to install SP1a first, then SP2, then SP3, or can I install SP3 immediately?