Tuesday , November 19 2024

The operating system returned the error ’59(An unexpected network error occurred.)’ while attempting ‘FlushFileBuffers’ on ‘myDB.BAK’

You may encounter this error when taking a backup to a NFS Mounted disk. You will see the error through SQL Server as follows.

Msg 3202, Level 16, State 1, Line 1

failed: 59(An unexpected network error occurred.)

Msg 3013, Level 16, State 1, Line 1

BACKUP DATABASE is terminating abnormally.

We are writing regedit.exe to run for solution.

You may think that changing registery keys is not very healthy as I thought at first. But this is the only solution to this problem as a result of my research. I’ve done this process so many times and I’ve never encountered any problems. Also my problem is solved without a server or service restart.

Go to “HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\lanmanworkstation\parameters” and right-click under paramaters and click on new to add a DWORD named SessTimeout as you see below.

I set the value to 3600. You can change this value by right-clicking on it and clicking modify.

Loading

About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

2 comments

  1. In your example, you’re setting 3600 as a hexadecimal value. If this is in seconds, and your intention is to have a timeout of 1 hour, then you need to click the “Decimal” radio button. How you’re currently setting it will give a timeout value of 3.84 hours.

    • I mentioned about only increasing this value in the article. And the value here is in milliseconds. You can choose decimal and set it to 60000 for “1 minute”.

Leave a Reply

Your email address will not be published. Required fields are marked *