Install SP4 + latest Hotfix | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Install SP4 + latest Hotfix

We need to upgrade SQL Server 2K SP3a on our Windows Server 2003 SP1 two
nodes Cluster and I have a doubt regarding how to install the latest hotfix.
The actual SQL Server Build is 8.00.0818
My intention is this: For Service Pack:
Backup all database.
Stop all monitoring software services like MOM.
Restart the servers before installing.
Remove or take offline all resources with dependencies on SQL Server.
Run the SP from the node that own the Group containing the Virtual Server to
upgrade. This should upgrade all nodes. Could you please instruct me on how to install the hotfix?
Is Build 2187 the latest? http://support.microsoft.com/kb/916287/ Cheers.
Please advise.
Franco
Yes that is the latest build and check the list of events from that KBA.
Refer tohttp://www.sql-server-performance.com/sqlserver2000_clustering_install_part3.asp to apply SP to a cluster instance. http://www.kbalertz.com/Feedback_914839.aspx too.
Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
We are trying to apply SP4 to SQL Server 2K SP3a, Build Number 8.00.818 but
we get this error after we write the name of the virtual server and click
next: Microsoft Visual C++Runtime Library: Buffer overrun detected!
Program:…DMIN~1Locals~Temp_ISTMP6.DIR_INS5576._MP
A buffer overrun has been detected which has corrupted the program’s
internal state. The program cannot safely continue execution and must now be
terminated. This is what we have done prior to trying to install SP4: Backup all database.
Stop all monitoring software services like MOM…
Restart the servers before installing.
Remove or take offline all resources with dependencies on SQL Server.
Run the SP from the node that own the Group containing the Virtual Server to
upgrade, but at this point the error show up. Any idea?
Please advise.
Franco
Ooh thats not good, linkhttp://www.sqlmag.com/Article/ArticleID/46852/sql_server_46852.html talks about few issue around the buffer overrun. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thank you for the link, but I have no access to all the article…
Do you know if there is a solution provided by Microsoft?
Please advise. Franco
There isn’t any from Microsoft, the best bet would be to call PSS in this case to get a hotfix.
I’m sure there was a hotfix available but not for public. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi,
is this what you are looking for ! its a link for build 2187 which is cumulative hotfix pack. : http://www.microsoft.com/downloads/…40-bdee-44df-b7a3-e6849297754a&DisplayLang=en Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

Thanks Satya,I will call PSS.
Ghemant, I think that build 2187 is a cumulative hotfix package AFTER SP4.
My problem is that I can’t even apply SP4 on my Cluster.
The strategy was to first install SP4 and then the cumulative package 2187.
Thank you anyway.
Cheers. Franco
Remove MSDTC Resource from SQL Sever Group was the solution.
SP4 was then succesfully installed.
Thank you for your reply and support. Franco
Hi,
thanks for sharing with us. Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

Appreciate your feedback Franco, on the other forum you’ve mentioned that you’re getting this with C++ component. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>