Applying sp3a patches to sql 2k | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Applying sp3a patches to sql 2k

Hi all, Please help me answer my dumb questions for me. I installed an evaluation copy of sql server 2k enterprise edition. After this installation, I downloaded and installed sp3a for sql 2k. A week ago, we installed a full licensed version of sql server 2k standard edition. I was under the impression that the sp3a patch we installed earlier would take care of t hat. But I just got a strong worded email from our dba that no sp3a patch was not applied to the newly installed sql server 2k. How can you check to determine whether sp3a patch is installed on sql 2k or not? Last but not list, when I tried installing that patch now, I got a message that said that sp3a had already been installed. So how can sp3a be applied to sql server 2k? Sorry for these cheap questions and I appreciate your response.
You can use: SELECT @@Version to see what version is installed…and use this link to find info on what the different versions mean: http://www.sql-server-performance.com/absolutenm/templates/?a=8&z=1 Cant help you with your second problem though sorry!
You should be able to install it even if it had been installed previously. But… in most shops that would be the responsibility of the DBA! Steve
You’ve downgraded the edition of SQL from EE to SE, so you must uninstall Evaluation Enterprise Edition and apply the SP3a to Standard edition. When you replace the evaluation edition with full edition, it is must and should to re-apply all the relevant hot fixes and service packs to get the server with latest patches.
http://support.microsoft.com/defaul…icepacks/SQL/2000/SP3ReadMe.asp#_removing_sp3 — FYi.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks to all for your response. Last night before I left, I discovered that you do select @@version to determine the version of sp on your sql server. I was shocked to find out that even the eval copy didn’t have sp3 applied even though that was installed by me after the eval copy was installed. Also, we are waiting to migrate data from the eval copy to the SE copy before uninstalling the eval copy. Satya,
What you are saying is that there is no way to apply the patch on SE version before uninstalling the other copy?
Return the SELECT @@VERSION value from Evaluation edition and Standard edition. If you have the Evaluation Enterprise Edition on the machine, the installation on Standard Edition will not proceed as it will look for the higher version. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Microsoft SQL Server 2000 – 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 5.2 (Build 3790: Service Pack 1, v.1069) Above is the read from EE If you have the Evaluation Enterprise Edition on the machine, the installation on Standard Edition will not proceed as it will look for the higher version. Ok, I got that, but why is EE edition still saying that it has only sp1, not sp3, even though sp3 has been installed? Ok, let me ask this: When I ran sp3, it says: sp3 has been delivered successfully. Doesn’t that mean that it has been installed, do I need to do something more?
Windows NT 5.2 (Build 3790: Service Pack 1, v.1069 – this represents SP1 for Windows 2000 not for SQL Server.
SQL Server 2000 – 8.00.760 – represents SP3a and in order to get mroe information about SP, run XP_MSVER from query analyzer.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
thank you Satya, I am getting a good lesson on this. What is confusing me right now is that the sp3 that I installed says sql2ksp3. That sounds to me like sql server 200k service pack 3, no? Wait, are you saying we may have installed sp3 for sql server, but not for windows? Why then is it, oh well do you have a link that can take me to sql server 2k sp3? This way, I can be sure it is for sql server, not windows. I ran XP_MSVER, what am I looking for?
Hi, When you are clicking on sql2ksp3, then it is showing package delivered. Right? Last day i had encountered same problem. same thing happened with me.
The problem is that when we double click on the sql2ksp3 then it asks us for the location, we give location and after some time it shows that package delivered. But it doesn’t mean that SP# has been installed. You just have to go to the location where you have unpacked the package and then your have to double click on ‘steup.bat’ file. Then installation wizard will come and you will be able to install, SQL Server Service pack SP3. Got it?

… exactly… good explanation by Arjun. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>