Netbackup 7.5.0.4 Backup SQL read from input socket failed(636)

[pellyaprai_prai]

Hello

I backup big sql database and met error 636. The child jobs are backed up success but parent job error 636. And database can restore normaly. The sql is in simple mode. how to create script for backup this mode ,transaction log .

Detail job

-------------

6/5/2013 12:11:52 AM - Info nbjm(pid=6012) starting backup job (jobid=35571) for client websql.nokair.co.th, policy MsSQL-WEBSQL_Full, schedule Full  

6/5/2013 12:11:52 AM - Info nbjm(pid=6012) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=35571, request id:{08E69880-32D3-47D4-AF58-726C3C9FBDB2})  

6/5/2013 12:11:52 AM - requesting resource websql01-hcart3-robot-tld-0

6/5/2013 12:11:52 AM - requesting resource netbackup01.nokair.co.th.NBU_CLIENT.MAXJOBS.websql.nokair.co.th

6/5/2013 12:11:52 AM - requesting resource netbackup01.nokair.co.th.NBU_POLICY.MAXJOBS.MsSQL-WEBSQL_Full

6/5/2013 12:11:52 AM - granted resource netbackup01.nokair.co.th.NBU_CLIENT.MAXJOBS.websql.nokair.co.th

6/5/2013 12:11:52 AM - granted resource netbackup01.nokair.co.th.NBU_POLICY.MAXJOBS.MsSQL-WEBSQL_Full

6/5/2013 12:11:52 AM - granted resource websql01-hcart3-robot-tld-0

6/5/2013 12:11:52 AM - estimated 0 Kbytes needed

6/5/2013 12:11:52 AM - Info nbjm(pid=6012) started backup (backupid=websql.nokair.co.th_1370365912) job for client websql.nokair.co.th, policy MsSQL-WEBSQL_Full, schedule Full on storage unit websql01-hcart3-robot-tld-0

6/5/2013 12:11:54 AM - Info bpbrm(pid=7520) websql.nokair.co.th is the host to backup data from     

6/5/2013 12:11:54 AM - Info bpbrm(pid=7520) reading file list from client        

6/5/2013 12:11:54 AM - started process bpbrm (7520)

6/5/2013 12:11:54 AM - connecting

6/5/2013 12:11:55 AM - Info bpbrm(pid=7520) starting bphdb on client         

6/5/2013 12:11:55 AM - Info bphdb(pid=4540) Backup started           

6/5/2013 12:11:55 AM - connected; connect time: 00:00:01

6/5/2013 12:11:58 AM - Info dbclient(pid=2328) INF - BACKUP STARTED USING        

6/5/2013 12:11:58 AM - Info dbclient(pid=2328) Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)    

6/5/2013 12:11:58 AM - Info dbclient(pid=2328) Apr  2 2010 15:48:46        

6/5/2013 12:11:58 AM - Info dbclient(pid=2328) Copyright (c) Microsoft Corporation         

6/5/2013 12:11:58 AM - Info dbclient(pid=2328) Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )  

6/5/2013 12:11:58 AM - Info dbclient(pid=2328) Batch = Z:\NetBackup\MsSql\bkup_full.bch, Op# = 1       

6/5/2013 12:11:59 AM - Info dbclient(pid=2328) INF - Using backup image WEBSQL01.MSSQL7.WEBSQL.db.aspnetdb.~.7.001of001.20130605001157..C       

6/5/2013 12:11:59 AM - Info dbclient(pid=2328) INF - backup database "aspnetdb" to VIRTUAL_DEVICE='VNBU0-2328-6780-1370365919' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2

6/5/2013 12:11:59 AM - Info dbclient(pid=2328) INF - Number of stripes: 1, Number of buffers per stripe 2. 

6/5/2013 12:11:59 AM - Info dbclient(pid=2328) INF - Created VDI object for SQL Server instance <WEBSQL>. Connection timeout is <300> seconds.

6/5/2013 12:12:34 AM - Info dbclient(pid=2328) INF - Thread has been closed for stripe #0    

6/5/2013 12:12:37 AM - Info dbclient(pid=2328) INF - OPERATION #1 of batch Z:\NetBackup\MsSql\bkup_full.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 40(2) seconds

6/5/2013 12:12:41 AM - Info dbclient(pid=2328) INF - BACKUP STARTED USING        

6/5/2013 12:12:41 AM - Info dbclient(pid=2328) Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)    

6/5/2013 12:12:41 AM - Info dbclient(pid=2328) Apr  2 2010 15:48:46        

6/5/2013 12:12:41 AM - Info dbclient(pid=2328) Copyright (c) Microsoft Corporation         

6/5/2013 12:12:41 AM - Info dbclient(pid=2328) Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )  

6/5/2013 12:12:41 AM - Info dbclient(pid=2328) Batch = Z:\NetBackup\MsSql\bkup_full.bch, Op# = 2       

6/5/2013 12:12:41 AM - Info dbclient(pid=2328) INF - Using backup image WEBSQL01.MSSQL7.WEBSQL.db.ASPState.~.7.001of001.20130605001240..C       

6/5/2013 12:12:41 AM - Info dbclient(pid=2328) INF - backup database "ASPState" to VIRTUAL_DEVICE='VNBU0-2328-5276-1370365961' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2

6/5/2013 12:12:41 AM - Info dbclient(pid=2328) INF - Number of stripes: 1, Number of buffers per stripe 2. 

6/5/2013 12:12:41 AM - Info dbclient(pid=2328) INF - Created VDI object for SQL Server instance <WEBSQL>. Connection timeout is <300> seconds.

6/5/2013 12:13:04 AM - Info dbclient(pid=2328) INF - Thread has been closed for stripe #0    

6/5/2013 12:13:07 AM - Info dbclient(pid=2328) INF - OPERATION #2 of batch Z:\NetBackup\MsSql\bkup_full.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 27(2) seconds

6/5/2013 12:13:10 AM - Info dbclient(pid=2328) INF - BACKUP STARTED USING        

6/5/2013 12:13:10 AM - Info dbclient(pid=2328) Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)    

6/5/2013 12:13:10 AM - Info dbclient(pid=2328) Apr  2 2010 15:48:46        

6/5/2013 12:13:10 AM - Info dbclient(pid=2328) Copyright (c) Microsoft Corporation         

6/5/2013 12:13:10 AM - Info dbclient(pid=2328) Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )  

6/5/2013 12:13:10 AM - Info dbclient(pid=2328) Batch = Z:\NetBackup\MsSql\bkup_full.bch, Op# = 3       

6/5/2013 12:13:11 AM - Info dbclient(pid=2328) INF - Using backup image WEBSQL01.MSSQL7.WEBSQL.db.ASPState2.~.7.001of001.20130605001309..C       

6/5/2013 12:13:11 AM - Info dbclient(pid=2328) INF - backup database "ASPState2" to VIRTUAL_DEVICE='VNBU0-2328-5848-1370365991' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2

6/5/2013 12:13:11 AM - Info dbclient(pid=2328) INF - Number of stripes: 1, Number of buffers per stripe 2. 

6/5/2013 12:13:11 AM - Info dbclient(pid=2328) INF - Created VDI object for SQL Server instance <WEBSQL>. Connection timeout is <300> seconds.

6/5/2013 12:13:33 AM - Info dbclient(pid=2328) INF - Thread has been closed for stripe #0    

6/5/2013 12:13:36 AM - Info dbclient(pid=2328) INF - OPERATION #3 of batch Z:\NetBackup\MsSql\bkup_full.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 27(1) seconds

6/5/2013 12:13:39 AM - Info dbclient(pid=2328) INF - BACKUP STARTED USING        

6/5/2013 12:13:39 AM - Info dbclient(pid=2328) Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)    

6/5/2013 12:13:39 AM - Info dbclient(pid=2328) Apr  2 2010 15:48:46        

6/5/2013 12:13:39 AM - Info dbclient(pid=2328) Copyright (c) Microsoft Corporation         

6/5/2013 12:13:39 AM - Info dbclient(pid=2328) Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )  

6/5/2013 12:13:39 AM - Info dbclient(pid=2328) Batch = Z:\NetBackup\MsSql\bkup_full.bch, Op# = 4       

6/5/2013 12:13:40 AM - Info dbclient(pid=2328) INF - Using backup image WEBSQL01.MSSQL7.WEBSQL.db.master.~.7.001of001.20130605001338..C       

6/5/2013 12:13:40 AM - Info dbclient(pid=2328) INF - backup database "master" to VIRTUAL_DEVICE='VNBU0-2328-2944-1370366020' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2

6/5/2013 12:13:40 AM - Info dbclient(pid=2328) INF - Number of stripes: 1, Number of buffers per stripe 2. 

6/5/2013 12:13:40 AM - Info dbclient(pid=2328) INF - Created VDI object for SQL Server instance <WEBSQL>. Connection timeout is <300> seconds.

6/5/2013 12:14:03 AM - Info dbclient(pid=2328) INF - Thread has been closed for stripe #0    

6/5/2013 12:14:05 AM - Info dbclient(pid=2328) INF - OPERATION #4 of batch Z:\NetBackup\MsSql\bkup_full.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 27(3) seconds

6/5/2013 12:14:09 AM - Info dbclient(pid=2328) INF - BACKUP STARTED USING        

6/5/2013 12:14:09 AM - Info dbclient(pid=2328) Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)    

6/5/2013 12:14:09 AM - Info dbclient(pid=2328) Apr  2 2010 15:48:46        

6/5/2013 12:14:09 AM - Info dbclient(pid=2328) Copyright (c) Microsoft Corporation         

6/5/2013 12:14:09 AM - Info dbclient(pid=2328) Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )  

6/5/2013 12:14:09 AM - Info dbclient(pid=2328) Batch = Z:\NetBackup\MsSql\bkup_full.bch, Op# = 5       

6/5/2013 12:14:09 AM - Info dbclient(pid=2328) INF - Using backup image WEBSQL01.MSSQL7.WEBSQL.db.model.~.7.001of001.20130605001407..C       

6/5/2013 12:14:09 AM - Info dbclient(pid=2328) INF - backup database "model" to VIRTUAL_DEVICE='VNBU0-2328-4532-1370366049' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2

6/5/2013 12:14:09 AM - Info dbclient(pid=2328) INF - Number of stripes: 1, Number of buffers per stripe 2. 

6/5/2013 12:14:09 AM - Info dbclient(pid=2328) INF - Created VDI object for SQL Server instance <WEBSQL>. Connection timeout is <300> seconds.

6/5/2013 12:14:33 AM - Info dbclient(pid=2328) INF - Thread has been closed for stripe #0    

6/5/2013 12:14:35 AM - Info dbclient(pid=2328) INF - OPERATION #5 of batch Z:\NetBackup\MsSql\bkup_full.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 28(2) seconds

6/5/2013 12:14:39 AM - Info dbclient(pid=2328) INF - BACKUP STARTED USING        

6/5/2013 12:14:39 AM - Info dbclient(pid=2328) Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)    

6/5/2013 12:14:39 AM - Info dbclient(pid=2328) Apr  2 2010 15:48:46        

6/5/2013 12:14:39 AM - Info dbclient(pid=2328) Copyright (c) Microsoft Corporation         

6/5/2013 12:14:39 AM - Info dbclient(pid=2328) Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )  

6/5/2013 12:14:39 AM - Info dbclient(pid=2328) Batch = Z:\NetBackup\MsSql\bkup_full.bch, Op# = 6       

6/5/2013 12:14:39 AM - Info dbclient(pid=2328) INF - Using backup image WEBSQL01.MSSQL7.WEBSQL.db.msdb.~.7.001of001.20130605001438..C       

6/5/2013 12:14:39 AM - Info dbclient(pid=2328) INF - backup database "msdb" to VIRTUAL_DEVICE='VNBU0-2328-6388-1370366079' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2

6/5/2013 12:14:39 AM - Info dbclient(pid=2328) INF - Number of stripes: 1, Number of buffers per stripe 2. 

6/5/2013 12:14:39 AM - Info dbclient(pid=2328) INF - Created VDI object for SQL Server instance <WEBSQL>. Connection timeout is <300> seconds.

6/5/2013 12:15:07 AM - Info dbclient(pid=2328) INF - Thread has been closed for stripe #0    

6/5/2013 12:15:10 AM - Info dbclient(pid=2328) INF - OPERATION #6 of batch Z:\NetBackup\MsSql\bkup_full.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 32(6) seconds

6/5/2013 12:15:13 AM - Info dbclient(pid=2328) INF - BACKUP STARTED USING        

6/5/2013 12:15:13 AM - Info dbclient(pid=2328) Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)    

6/5/2013 12:15:13 AM - Info dbclient(pid=2328) Apr  2 2010 15:48:46        

6/5/2013 12:15:13 AM - Info dbclient(pid=2328) Copyright (c) Microsoft Corporation         

6/5/2013 12:15:13 AM - Info dbclient(pid=2328) Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )  

6/5/2013 12:15:13 AM - Info dbclient(pid=2328) Batch = Z:\NetBackup\MsSql\bkup_full.bch, Op# = 7       

6/5/2013 12:15:13 AM - Info dbclient(pid=2328) INF - Using backup image WEBSQL01.MSSQL7.WEBSQL.db.NokConnext.~.7.001of001.20130605001512..C       

6/5/2013 12:15:14 AM - Info dbclient(pid=2328) INF - backup database "NokConnext" to VIRTUAL_DEVICE='VNBU0-2328-4140-1370366113' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2

6/5/2013 12:15:14 AM - Info dbclient(pid=2328) INF - Number of stripes: 1, Number of buffers per stripe 2. 

6/5/2013 12:15:14 AM - Info dbclient(pid=2328) INF - Created VDI object for SQL Server instance <WEBSQL>. Connection timeout is <300> seconds.

6/5/2013 12:28:39 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]10 percent processed.>.

6/5/2013 12:47:30 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]20 percent processed.>.

6/5/2013 1:10:07 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]30 percent processed.>.

6/5/2013 1:32:59 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]40 percent processed.>.

6/5/2013 1:58:53 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]50 percent processed.>.

read from input socket failed(636)

6/5/2013 2:24:21 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]60 percent processed.>.

6/5/2013 2:51:00 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]70 percent processed.>.

6/5/2013 3:17:39 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]80 percent processed.>.

6/5/2013 3:43:53 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]90 percent processed.>.

6/5/2013 4:08:56 AM - Info dbclient(pid=2328) INF - Thread has been closed for stripe #0    

6/5/2013 4:09:03 AM - Info dbclient(pid=2328) INF - OPERATION #7 of batch Z:\NetBackup\MsSql\bkup_full.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 14031(14001) seconds

6/5/2013 4:09:06 AM - Info dbclient(pid=2328) INF - BACKUP STARTED USING        

6/5/2013 4:09:06 AM - Info dbclient(pid=2328) Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)    

6/5/2013 4:09:06 AM - Info dbclient(pid=2328) Apr  2 2010 15:48:46        

6/5/2013 4:09:06 AM - Info dbclient(pid=2328) Copyright (c) Microsoft Corporation         

6/5/2013 4:09:06 AM - Info dbclient(pid=2328) Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )  

6/5/2013 4:09:06 AM - Info dbclient(pid=2328) Batch = Z:\NetBackup\MsSql\bkup_full.bch, Op# = 8       

6/5/2013 4:09:07 AM - Info dbclient(pid=2328) INF - Using backup image WEBSQL01.MSSQL7.WEBSQL.db.Nokpay.~.7.001of001.20130605040905..C       

6/5/2013 4:09:07 AM - Info dbclient(pid=2328) INF - backup database "Nokpay" to VIRTUAL_DEVICE='VNBU0-2328-4084-1370380147' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2

6/5/2013 4:09:07 AM - Info dbclient(pid=2328) INF - Number of stripes: 1, Number of buffers per stripe 2. 

6/5/2013 4:09:07 AM - Info dbclient(pid=2328) INF - Created VDI object for SQL Server instance <WEBSQL>. Connection timeout is <300> seconds.

6/5/2013 4:10:26 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]10 percent processed.>.

6/5/2013 4:11:18 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]20 percent processed.>.

6/5/2013 4:12:10 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]30 percent processed.>.

6/5/2013 4:13:02 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]40 percent processed.>.

6/5/2013 4:13:59 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]50 percent processed.>.

6/5/2013 4:14:56 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]60 percent processed.>.

6/5/2013 4:15:53 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]70 percent processed.>.

6/5/2013 4:16:40 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]80 percent processed.>.

6/5/2013 4:17:32 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]90 percent processed.>.

6/5/2013 4:18:15 AM - Info dbclient(pid=2328) INF - Thread has been closed for stripe #0    

6/5/2013 4:18:19 AM - Info dbclient(pid=2328) INF - OPERATION #8 of batch Z:\NetBackup\MsSql\bkup_full.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 554(524) seconds

6/5/2013 4:18:23 AM - Info dbclient(pid=2328) INF - BACKUP STARTED USING        

6/5/2013 4:18:23 AM - Info dbclient(pid=2328) Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)    

6/5/2013 4:18:23 AM - Info dbclient(pid=2328) Apr  2 2010 15:48:46        

6/5/2013 4:18:23 AM - Info dbclient(pid=2328) Copyright (c) Microsoft Corporation         

6/5/2013 4:18:23 AM - Info dbclient(pid=2328) Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )  

6/5/2013 4:18:23 AM - Info dbclient(pid=2328) Batch = Z:\NetBackup\MsSql\bkup_full.bch, Op# = 9       

6/5/2013 4:18:23 AM - Info dbclient(pid=2328) INF - Using backup image WEBSQL01.MSSQL7.WEBSQL.db.NokSky.~.7.001of001.20130605041822..C       

6/5/2013 4:18:23 AM - Info dbclient(pid=2328) INF - backup database "NokSky" to VIRTUAL_DEVICE='VNBU0-2328-5844-1370380703' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2

6/5/2013 4:18:23 AM - Info dbclient(pid=2328) INF - Number of stripes: 1, Number of buffers per stripe 2. 

6/5/2013 4:18:24 AM - Info dbclient(pid=2328) INF - Created VDI object for SQL Server instance <WEBSQL>. Connection timeout is <300> seconds.

6/5/2013 4:18:51 AM - Info dbclient(pid=2328) INF - Thread has been closed for stripe #0    

6/5/2013 4:18:53 AM - Info dbclient(pid=2328) INF - OPERATION #9 of batch Z:\NetBackup\MsSql\bkup_full.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 31(6) seconds

6/5/2013 4:18:57 AM - Info dbclient(pid=2328) INF - BACKUP STARTED USING        

6/5/2013 4:18:57 AM - Info dbclient(pid=2328) Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)    

6/5/2013 4:18:57 AM - Info dbclient(pid=2328) Apr  2 2010 15:48:46        

6/5/2013 4:18:57 AM - Info dbclient(pid=2328) Copyright (c) Microsoft Corporation         

6/5/2013 4:18:57 AM - Info dbclient(pid=2328) Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )  

6/5/2013 4:18:57 AM - Info dbclient(pid=2328) Batch = Z:\NetBackup\MsSql\bkup_full.bch, Op# = 10       

6/5/2013 4:18:57 AM - Info dbclient(pid=2328) INF - Using backup image WEBSQL01.MSSQL7.WEBSQL.db.SkySpeedTracker.~.7.001of001.20130605041856..C       

6/5/2013 4:18:57 AM - Info dbclient(pid=2328) INF - backup database "SkySpeedTracker" to VIRTUAL_DEVICE='VNBU0-2328-6840-1370380737' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2

6/5/2013 4:18:57 AM - Info dbclient(pid=2328) INF - Number of stripes: 1, Number of buffers per stripe 2. 

6/5/2013 4:18:57 AM - Info dbclient(pid=2328) INF - Created VDI object for SQL Server instance <WEBSQL>. Connection timeout is <300> seconds.

6/5/2013 4:19:41 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]10 percent processed.>.

6/5/2013 4:19:58 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]20 percent processed.>.

6/5/2013 4:20:15 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]30 percent processed.>.

6/5/2013 4:20:37 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]40 percent processed.>.

6/5/2013 4:20:48 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]50 percent processed.>.

6/5/2013 4:21:10 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]60 percent processed.>.

6/5/2013 4:21:32 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]70 percent processed.>.

6/5/2013 4:21:49 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]80 percent processed.>.

6/5/2013 4:22:05 AM - Info dbclient(pid=2328) INF - ODBC return code <2>, SQL State <01000>, SQL Message <3211><[Microsoft][ODBC SQL Server Driver][SQL Server]90 percent processed.>.

6/5/2013 4:22:24 AM - Info dbclient(pid=2328) INF - Thread has been closed for stripe #0    

6/5/2013 4:22:28 AM - Info dbclient(pid=2328) INF - OPERATION #10 of batch Z:\NetBackup\MsSql\bkup_full.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 212(186) seconds

6/5/2013 4:22:30 AM - Info dbclient(pid=2328) INF - Results of executing <Z:\NetBackup\MsSql\bkup_full.bch>:       

6/5/2013 4:22:30 AM - Info dbclient(pid=2328) <10> operations succeeded. <0> operations failed.       

thank you

[Yasuhisa_Ishika]

Did it happen occasionally? Or do you always get status code 636 in this SQL backup?
Have you already tried to increase Client Read Timeout? Any clue in windows event log and netbackup logs like dbclient, bphdb, bprd, etc...

[Marianne · Accepted solution]

Is there a firewall between the media server and the master?

Errors like these are normally caused by firewall timeouts because bpbrm is sending no updates to bpdbm or job manager while large database is being backed up.

Changing KeepAlive setting on master and media server normally helps. 
See https://www-secure.symantec.com/connect/forums/sql-backups-run-fine-parent-job-ends-error-636#commen...

[huanglao2002]

Hi, i have encount the same error.

1 try to increace the firewall connect time out, bigger than "backup time"

2 change "KeepAlive" smaller then firewall timeout.

hope it's help.

[pellyaprai_prai]

Yes ,I add firewall connectt time out but still error