Error Message
Msg 823, Level 24, State 2, Procedure tables, Line 2 [Batch Start Line 2]
The operating system returned error 59(An unexpected network error occurred.) to SQL Server during a read
at offset 0x00004675548000 in file '\\Server_Name\D2A_DB\MSSQL\Data\HISTORICAL_NDF_1.ndf'.
Additional messages in the SQL Server error log and operating system error log may provide more detail.
This is a severe system-level error condition that threatens database integrity and must be corrected
immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many
factors; for more information, see SQL Server Books Online.
Cause
The Windows Session Timeout is 60 s by default. This timeout is dependent not only on Data Domain response time,
but also any network latency.
If there is a slow network or longer than expected Data Domain processing (such as rapid index expansion under
a heavy backup load), Windows resets the connection causing backup errors.
PS C:\Windows\system32> get-SmbClientConfiguration
Resolution
Increase the Windows Session Timeout to a higher value such as 180 s by running the following command:
PS C:\Windows\system32> Set-SmbClientConfiguration -SessionTimeout 180 -Force