SQL Server Performance Forum – Threads Archive
SP1 and Named InstanceI have a server running 2 instances of sql server 2005, the default, and 1 named instance.<br /><br />How do i apply sp1 to the named instance without affecting the default instance? I ran the sp1 install on my development server just to examine the steps, expecting a dialog where it let me choose the instance I wanted to upgrade, and the opportunity to choose never came.<br /><br />thanks<br />[<img src=’/community/emoticons/emotion-3.gif’ alt=’‘ />)]<br />daustinash<br /><br /><br />daustinash<br />[email protected]
Through command prompt you can initiate to install SP1 by specifying the instance name as well on which sp1 needs to be applied.
for eg: from command prompt run this:
Cathofsqlsp1installableSQLServer2005SP1-KB913090-x86-ENU.exe /? and then you can see the /instancename option by running above statement.
Thanks ranjitjain. This seems to be pretty hidden info. A google search turns up nothing. I’ll give it a try. daustinash
SQL Server service pack and hotfix application is independant of SQL instance, as suggested you can apply to a named instance alone without doing anything to default instance. But when it refers to reboot then make sure the applications on default instance has a downtime during this period. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.
I am sure there is an option choose INSTANCE name to apply the service pack or patch…even sql 2000 has that option and it should be there in 2005 too… Your Dev server is multi instance or single instance server? You can test this on your laptop by installing two instances… Mohammed U.