Post reply

SQL 2016 restore fails with error: A transport-level error has occurred when receiving results from the server...

  • May 23, 2017 at 3:55 pm

    #402090

    Hello experts,

    I am trying to restore a database on a SQL 2016 server, but the restore keeps failing midway through with this error:

    Msg 10054, Level 20, State 0, Line 217
    A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

    I searched the error and found this link:
    https://support.microsoft.com/en-us/help/942861/-general-network-error,-communication-link-failure,-or-a-transport-level-error-message-when-an-application-connects-to-sql-server

    One suggestion in the link is to run this command:: Netsh int tcp show global

    I did so - the results are below. 

    Results from a SQL 2012 server where restores are working:

    Microsoft Windows [Version 6.1.7601]
    Copyright (c) 2009 Microsoft Corporation. All rights reserved.

    C:\Windows\system32>Netsh int tcp show global
    Querying active state...

    TCP Global Parameters
    ----------------------------------------------
    Receive-Side Scaling State    : enabled
    Chimney Offload State     : automatic
    NetDMA State        : enabled
    Direct Cache Acess (DCA)    : disabled
    Receive Window Auto-Tuning Level  : normal
    Add-On Congestion Control Provider : ctcp
    ECN Capability        : disabled
    RFC 1323 Timestamps      : disabled

    And these are the results from the SQL 2016 server where the restore is failing:

    C:\Windows\system32>Netsh int tcp show global
    Querying active state...

    TCP Global Parameters
    ----------------------------------------------
    Receive-Side Scaling State    : enabled
    Chimney Offload State     : disabled
    NetDMA State        : disabled
    Direct Cache Access (DCA)    : disabled
    Receive Window Auto-Tuning Level  : normal
    Add-On Congestion Control Provider : none
    ECN Capability        : enabled
    RFC 1323 Timestamps      : disabled
    Initial RTO         : 3000
    Receive Segment Coalescing State  : enabled
    Non Sack Rtt Resiliency     : disabled
    Max SYN Retransmissions     : 2

    Can anyone point me in the direction of further troubleshooting, since I would rather be able to confirm a more definitive root cause possibility before trying changes to these settings?

    Thanks for any help!

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • May 24, 2017 at 8:36 am

    #1943998

    You might want to take a look at this article - it lists some other possible causes as well as explains the TCP Chimney changes a bit more, with additional links:
    TCP Chimney Setting and SQL Server Error: TCP Provider: An existing connection was forcibly closed by the remote host

    I'd check for updates for the network card drivers before changing the settings. 

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply