Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Backup and Recovery Community Blog

Socket read failed OR the connection was terminated and 0×80770004

Created: 14 Jul 2011
Zahid.Haseeb's picture
0 0 Votes
Login to vote

The restore is being failed on a SQL Server 2008 R2 machine and the backup took from a SQL Server 2005 machine.

Environment

Veritas Netbackup Server = 7.1

Veritas Netbackup Client = 7.1

Veritas Netbackup Client Product = SQL Server 2008 R2 (on which the data is being restore)

Veritas Netbackup Client Product = SQL Server 2005 (through which the data is backed up)

Activity Monitor Parent Job

7/10/2011 1:00:58 PM - Info dbclient(pid=10148) DBMS MSG - SQL Message <11><[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.>
7/10/2011 1:00:58 PM - Info dbclient(pid=10148) ERR - Error found executing <restore database "ServerDBDotNet" from VIRTUAL_DEVICE='VNBU0-10148-10168-1310279348' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 1, replace , norecovery, move 'ServeDnet_Data' to 'R:\DBDATA\ServerDBdotNet.mdf', move 'XYlive to 'G:\DBDATA\ServerDBdotnet_XY_Live.NDF', move 'XYhs' to 'H:\DBDATA\ServerDBdotnet_XY_hs.NDF', move 'Lordms' to 'B:\DBDATA\ServerDBdotnet_Lordms.NDF', move 'ServeDnet_Log' to 'T:\DBDATA\ServerDBdotNet_log.ldf', replace>.
7/10/2011 1:01:00 PM - Info dbclient(pid=10148) ERR - Error in VDS->Close: 0x80770004.       
7/10/2011 1:01:00 PM - Info dbclient(pid=10148)     CONTINUATION: - An abort request is preventing anything except termination actions.
7/10/2011 1:01:00 PM - Info dbclient(pid=10148) INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\Mig_NEW09072011.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 5516(5516) seconds.
7/10/2011 1:01:03 PM - Info dbclient(pid=10148) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\Mig_NEW09072011.bch>:      
7/10/2011 1:01:03 PM - Info dbclient(pid=10148) <0> operations succeeded. <1> operations failed.   

Activity Monitor Child Job

7/10/2011 12:44:35 PM - Error bpbrm(pid=732) socket read failed, An existing connection was forcibly closed by the remote host.  (10054)
7/10/2011 12:44:35 PM - Info bpbrm(pid=5280) child done, status 13         
7/10/2011 12:44:35 PM - Info bpbrm(pid=5280) sending media manager msg: TERMINATE        
7/10/2011 12:44:35 PM - restored image DB-Cluster_1310220261 - (file read failed(13)); restore time 01:05:49
7/10/2011 12:44:41 PM - end Restore; elapsed time: 01:15:30
invalid error number(2826)

DBclient

13:01:01.916 [10148.10168] <16> writeToServer: ERR - send() to server on socket failed:

13:01:01.916 [10148.10168] <16> dbc_RemoteWriteFile: ERR - could not write progress status message to the NAME socket

13:01:01.916 [10148.10168] <16> CDBbackrec::FreeDeviceSet(): ERR - Error in VDS->Close: 0x80770004.

Resolution

1.) As per the logs, it seems the connection was terminated. The socket was being forcibly closed prior to completion of data transfer. Could be a timeout issue. read more