none
CU Update to Sql Server 2014 hangs for 7 hours

    Question

  • How to make applying the SP2 CU5 update faster? 

    Applying patches on test Hyper-V VM's prior to production patching.   Message for 7 hours is
    "Please wait while Microsoft SQL Server 2014 Setup processes the current operation."

    It is a two node Always-On AG.

    From Detail.txt when I let it run:

    (01)2017-04-2615:55:36Slp:Running discovery onremote machine:SQLHADEV1

    (01)2017-04-2621:48:32Slp:Discovery onSQLHADEV1 iscomplete

    Things I've checked/done:

    1. Resources are lightly used shown in task manager
    2. Validated the Cluster
    3. Overkill on security, the account running the SQL Services on both nodes is sysadmin on both nodes
    4. Attempted to get cluster log but it error-ed

      PS SQLSERVER:\>Get-ClusterLog -Destination C:\tempsql 
      Get-ClusterLog :The network name cannot be found.
    5. Tested install media on non-AG local box and it installed as expected

    6. Applied windows updates on both servers, failed over, failed back, and restarted servers. Successful automatic failover
    8. Ran the patch install on a non-AG Hyper-V VM successfully
    9. No errors or messages in the Windows Event Logs or SQL Server event logs on either node that are telling.


    Barbara Novak

    Friday, April 28, 2017 8:45 PM

All replies

  • Hi Barbara,

    I have faced similar situation in SQL Server 2008 r2 and I believed it was some limitation but when I tried SQL Server 2012 did not faced this issue.

    I was applying patch on SQL Server 7 node cluster so it was even worse for me.

    I would like you to check following

    1. Answer mentioned in this Thread

    2. Network connection between VM's connected.

    Unfortunately I did not found out solution for such thing and I used some different method which I really dont remember as of now.


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Saturday, April 29, 2017 3:00 PM
    Moderator