SQL Server Performance

Install SP4 + latest Hotfix

Discussion in 'SQL Server Clustering' started by franco, May 19, 2006.

  1. franco New Member

    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
  2. satya Moderator

  3. franco New Member

    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
  4. satya Moderator

  5. franco New Member

    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
  6. satya Moderator

    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.
  7. ghemant Moderator

  8. franco New Member

    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
  9. franco New Member

    Remove MSDTC Resource from SQL Sever Group was the solution.
    SP4 was then succesfully installed.
    Thank you for your reply and support.

    Franco
  10. ghemant Moderator

    Hi,
    thanks for sharing with us.

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
  11. satya Moderator

    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.

Share This Page