SQL Server restore fails when you restore a SQL Server compressed backup image as a single stripe or with multiple stripes
This issue occurs when SQL Server is busy with the buffer of compressed data and cannot process all the data that is sent within a certain length of time. By default in Windows Server, TCP connections must close after the TCP connection state has been set to FIN_WAIT_2 for two minutes. Refer to the following Microsoft article for more information:
https://support.microsoft.com/en-us/kb/923200/
Note:
If the value does not exist, you must create it as a REG_DWORD registry value. Otherwise, Windows uses the default value of .
To increase the time that TCP connections may remain in the FIN_WAIT_2 state
- On the NetBackup media server, open
regedit.exe. - Locate and select the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters - Double-click on TCPFinWait2Delay.
- Enter a value of 300.
- Restart the media server.
- After the restore completes successfully, remove the registry setting or change the setting to its original value.
When you increase the value of this setting it has an adverse effect for all TCP/IP connections. This higher value could cause port exhaustion for other applications that run on the media server.
- Restart the media server.