SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Steps to install Service Pack for SQL Server 2005 – Multiple Instances

Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :-

Step 1 : First page of Service pack setup. Informatory details only.

Step 2 : Confirm EULA (End User License Agreement) to move ahead.

Step 3 : Select instance & features you want to patch or upgrade.

Note : You can upgrade or patch all available SQL Server instances in one go. You can select the check box of each component or available instance to upgrade that in same installation.

Step 4 : Provide authentication details to setup to connect to Database Engine to execute upgrade scripts etc.

Step 5 : Select checkbox, if you want to report error & usage details to Microsoft.

Step 6 : Currently, Below files related to SQL Server are in use. Instillation need lock on these files to upgrade them during installation. Microsoft is quite smart here, You can continue with your installation when these files is in use. Only impact if that, You need to reboot your Windows box aafter installation so that after reboot SQL can replace the below files with upgraded one to continue with upgraded version.

Step 7 : You have provided all details, Now click on install & relax.

Step 8 : Installation completed.

Step 9 : You can view installation summary for more details. More useful in case of any issue or errors.

Step 10 : Additional step, you can click finish & you are done.

Normally, We do not perform Provisioning step on servers.

Step 11 : Reboot Windows Box.

Step 12 : Check SQL server version, SQL Jobs, Backup status, Windows error log, SQL error log as sanity check to check, if we face any issue after patching.

If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun

Reference : Rohit Garg (http://mssqlfun.com/)


I, Rohit Garg, am working as Consultant in IT Company. I am having an around 5 years of experience in MSSQL server & other Microsoft technologies. I am working as DBA in Microsoft SQL Server from last 5 years in e-Commerce, Telecom, Finance domain. In this tenure, I got a chance of working as Database administrator, Developer and trainer on SQL server 2000 to SQL Server 2012. I am holding Master’s degree in Computer Science along with certification in SQL Server & .Net. I like to learn new things by hand-on experience on regular basis. This journey is so far is delightful & valuable with the addition of wonderful friends.


Leave a comment on the original post [mssqlfun.com, opens in a new window]

Loading comments...