Video Screencast Help

SQL BackUp Partially Successful

Created: 04 Oct 2012 | 4 comments
itsmeLuck's picture

Hi Team,

 

I would need help to finish this error that I am encountering, Im using NBU 7.5.0.3 with windows 2008 R2 server, the SQL back up showing partially successful and I seem to have a hard time finding the cause of the back up that is partially successful.

 

Below is the the bphdb log of the SQL client that is bein backed up, I hope you could help me on this, any help would be greatly appreciated.

 

 

00:30:05.758 [6824.4656] <2> logparams: -sb -rdbms sql_server -S msmbcmph101f -to 144000 -c miagcmph101-DB1_db_diff_policy -s DB_Diff_Backup -clnt miagcmph101 -FULL -kl 28 -b miagcmph101_1349195400 -jobid 12153 
00:30:05.772 [6824.4656] <4> bphdb: Module: libncf, Release: 7.5.0.3 , Build: 06/05/2012 20:00:00 CDT (20120605)
00:30:05.778 [6824.4656] <4> bphdb: Windows version: 6.1.7601, Platform: 2 (Service Pack 1), Service pack: 1.0, Suite: 272, Product type: 3
00:30:05.783 [6824.4656] <4> bphdb: Process architecture: 9, Page size: 4096, Process type: 2, Process level: 8664, Processor revision: 6
00:30:05.788 [6824.4656] <4> bphdb: Current code page: WINDOWS: 1252  (ANSI - Latin I), Max. character width: 1, Substitution character: 0x3F [?], Unicode substitution character: 0x003f [?.]
00:30:05.788 [6824.4656] <4> bphdb: INF - BACKUP START 6824
00:30:05.789 [6824.4656] <4> bphdb: INF - CONTINUE BACKUP message received
 
00:30:05.789 [6824.4656] <4> bphdb: INF - Processing C:\Program?Files\Veritas\NetBackup\DbExt\MsSql\miagcmph101_diff.bch
00:31:05.792 [6824.4656] <4> bphdb: INF - bphdb still working.
00:31:31.565 [6824.4656] <4> bphdb: INF - command successfully initiated
00:31:31.565 [6824.4656] <4> bphdb: ERR - exit status  :  (0)
00:31:31.565 [6824.4656] <4> bphdb: INF - bphdb exit normal
 
00:31:31.565 [6824.4656] <4> bphdb: INF - EXIT STATUS 0: the requested operation was successfully completed
 
01:30:06.951 [6652.4336] <2> logparams: -sb -rdbms sql_server -S msmbcmph101f -to 144000 -c miagcmph101_db_Trx_policy -s DB_Trx_Backup_no_Trunc -clnt miagcmph101 -FULL -kl 28 -b miagcmph101_1349199001 -jobid 12178 
01:30:06.965 [6652.4336] <4> bphdb: Module: libncf, Release: 7.5.0.3 , Build: 06/05/2012 20:00:00 CDT (20120605)
01:30:06.970 [6652.4336] <4> bphdb: Windows version: 6.1.7601, Platform: 2 (Service Pack 1), Service pack: 1.0, Suite: 272, Product type: 3
01:30:06.975 [6652.4336] <4> bphdb: Process architecture: 9, Page size: 4096, Process type: 2, Process level: 8664, Processor revision: 6
01:30:06.980 [6652.4336] <4> bphdb: Current code page: WINDOWS: 1252  (ANSI - Latin I), Max. character width: 1, Substitution character: 0x3F [?], Unicode substitution character: 0x003f [?.]
01:30:06.980 [6652.4336] <4> bphdb: INF - BACKUP START 6652
01:30:06.981 [6652.4336] <4> bphdb: INF - CONTINUE BACKUP message received
 
01:30:06.981 [6652.4336] <4> bphdb: INF - Processing C:\Program?Files\Veritas\NetBackup\DbExt\MsSql\miagcmph101_no_Trunc.bch
01:31:06.984 [6652.4336] <4> bphdb: INF - bphdb still working.
01:32:06.986 [6652.4336] <4> bphdb: INF - bphdb still working.
01:33:06.989 [6652.4336] <4> bphdb: INF - bphdb still working.
01:34:06.987 [6652.4336] <4> bphdb: INF - bphdb still working.
01:35:07.044 [6652.4336] <4> bphdb: INF - bphdb still working.
01:36:07.042 [6652.4336] <4> bphdb: INF - bphdb still working.
01:36:20.462 [6652.4336] <16> bphdb: ERR - command failed: the requested operation was partially successful (1)
01:36:20.462 [6652.4336] <4> bphdb: ERR - exit status  :  (1)
01:36:20.462 [6652.4336] <16> bphdb: ERR - bphdb exit status = 1: the requested operation was partially successful
 
01:36:20.463 [6652.4336] <4> bphdb: INF - EXIT STATUS 1: the requested operation was partially successful
 
02:30:06.503 [7016.5492] <2> logparams: -sb -rdbms sql_server -S msmbcmph101f -to 144000 -c miagcmph101_db_Trx_policy -s DB_Trx_Backup_no_Trunc -clnt miagcmph101 -FULL -kl 28 -b miagcmph101_1349202601 -jobid 12194 
02:30:06.519 [7016.5492] <4> bphdb: Module: libncf, Release: 7.5.0.3 , Build: 06/05/2012 20:00:00 CDT (20120605)
02:30:06.526 [7016.5492] <4> bphdb: Windows version: 6.1.7601, Platform: 2 (Service Pack 1), Service pack: 1.0, Suite: 272, Product type: 3
02:30:06.531 [7016.5492] <4> bphdb: Process architecture: 9, Page size: 4096, Process type: 2, Process level: 8664, Processor revision: 6
02:30:06.536 [7016.5492] <4> bphdb: Current code page: WINDOWS: 1252  (ANSI - Latin I), Max. character width: 1, Substitution character: 0x3F [?], Unicode substitution character: 0x003f [?.]
02:30:06.537 [7016.5492] <4> bphdb: INF - BACKUP START 7016
02:30:06.538 [7016.5492] <4> bphdb: INF - CONTINUE BACKUP message received
 
02:30:06.539 [7016.5492] <4> bphdb: INF - Processing C:\Program?Files\Veritas\NetBackup\DbExt\MsSql\miagcmph101_no_Trunc.bch
02:31:06.535 [7016.5492] <4> bphdb: INF - bphdb still working.
02:32:06.531 [7016.5492] <4> bphdb: INF - bphdb still working.
02:33:06.528 [7016.5492] <4> bphdb: INF - bphdb still working.
02:34:06.529 [7016.5492] <4> bphdb: INF - bphdb still working.
02:35:06.532 [7016.5492] <4> bphdb: INF - bphdb still working.
02:36:06.534 [7016.5492] <4> bphdb: INF - bphdb still working.
02:36:26.179 [7016.5492] <16> bphdb: ERR - command failed: the requested operation was partially successful (1)
02:36:26.179 [7016.5492] <4> bphdb: ERR - exit status  :  (1)
02:36:26.179 [7016.5492] <16> bphdb: ERR - bphdb exit status = 1: the requested operation was partially successful
 
02:36:26.179 [7016.5492] <4> bphdb: INF - EXIT STATUS 1: the requested operation was partially successful
 
03:30:06.780 [3792.6008] <2> logparams: -sb -rdbms sql_server -S msmbcmph101f -to 144000 -c miagcmph101_db_Trx_policy -s DB_Trx_Backup_no_Trunc -clnt miagcmph101 -FULL -kl 28 -b miagcmph101_1349206201 -jobid 12201 
03:30:06.794 [3792.6008] <4> bphdb: Module: libncf, Release: 7.5.0.3 , Build: 06/05/2012 20:00:00 CDT (20120605)
03:30:06.799 [3792.6008] <4> bphdb: Windows version: 6.1.7601, Platform: 2 (Service Pack 1), Service pack: 1.0, Suite: 272, Product type: 3
03:30:06.803 [3792.6008] <4> bphdb: Process architecture: 9, Page size: 4096, Process type: 2, Process level: 8664, Processor revision: 6
03:30:06.808 [3792.6008] <4> bphdb: Current code page: WINDOWS: 1252  (ANSI - Latin I), Max. character width: 1, Substitution character: 0x3F [?], Unicode substitution character: 0x003f [?.]
03:30:06.808 [3792.6008] <4> bphdb: INF - BACKUP START 3792
03:30:06.809 [3792.6008] <4> bphdb: INF - CONTINUE BACKUP message received
 
03:30:06.809 [3792.6008] <4> bphdb: INF - Processing C:\Program?Files\Veritas\NetBackup\DbExt\MsSql\miagcmph101_no_Trunc.bch
03:31:06.813 [3792.6008] <4> bphdb: INF - bphdb still working.
03:32:06.815 [3792.6008] <4> bphdb: INF - bphdb still working.
03:33:06.816 [3792.6008] <4> bphdb: INF - bphdb still working.
03:34:06.812 [3792.6008] <4> bphdb: INF - bphdb still working.
03:35:06.816 [3792.6008] <4> bphdb: INF - bphdb still working.
03:36:06.812 [3792.6008] <4> bphdb: INF - bphdb still working.
03:36:23.028 [3792.6008] <16> bphdb: ERR - command failed: the requested operation was partially successful (1)
03:36:23.028 [3792.6008] <4> bphdb: ERR - exit status  :  (1)
03:36:23.028 [3792.6008] <16> bphdb: ERR - bphdb exit status = 1: the requested operation was partially successful
 
03:36:23.028 [3792.6008] <4> bphdb: INF - EXIT STATUS 1: the requested operation was partially successful
 
04:30:06.189 [5876.392] <2> logparams: -sb -rdbms sql_server -S msmbcmph101f -to 144000 -c miagcmph101_db_Trx_policy -s DB_Trx_Backup_no_Trunc -clnt miagcmph101 -FULL -kl 28 -b miagcmph101_1349209801 -jobid 12208 
04:30:06.212 [5876.392] <4> bphdb: Module: libncf, Release: 7.5.0.3 , Build: 06/05/2012 20:00:00 CDT (20120605)
04:30:06.220 [5876.392] <4> bphdb: Windows version: 6.1.7601, Platform: 2 (Service Pack 1), Service pack: 1.0, Suite: 272, Product type: 3
04:30:06.225 [5876.392] <4> bphdb: Process architecture: 9, Page size: 4096, Process type: 2, Process level: 8664, Processor revision: 6
04:30:06.229 [5876.392] <4> bphdb: Current code page: WINDOWS: 1252  (ANSI - Latin I), Max. character width: 1, Substitution character: 0x3F [?], Unicode substitution character: 0x003f [?.]
04:30:06.229 [5876.392] <4> bphdb: INF - BACKUP START 5876
04:30:06.230 [5876.392] <4> bphdb: INF - CONTINUE BACKUP message received
 
04:30:06.230 [5876.392] <4> bphdb: INF - Processing C:\Program?Files\Veritas\NetBackup\DbExt\MsSql\miagcmph101_no_Trunc.bch
04:31:06.234 [5876.392] <4> bphdb: INF - bphdb still working.
04:32:06.236 [5876.392] <4> bphdb: INF - bphdb still working.
04:33:06.236 [5876.392] <4> bphdb: INF - bphdb still working.
04:34:06.232 [5876.392] <4> bphdb: INF - bphdb still working.
04:35:06.228 [5876.392] <4> bphdb: INF - bphdb still working.
04:36:06.224 [5876.392] <4> bphdb: INF - bphdb still working.
04:36:20.617 [5876.392] <16> bphdb: ERR - command failed: the requested operation was partially successful (1)
04:36:20.617 [5876.392] <4> bphdb: ERR - exit status  :  (1)
04:36:20.617 [5876.392] <16> bphdb: ERR - bphdb exit status = 1: the requested operation was partially successful
 
04:36:20.617 [5876.392] <4> bphdb: INF - EXIT STATUS 1: the requested operation was partially successful
 
05:30:06.639 [5160.6764] <2> logparams: -sb -rdbms sql_server -S msmbcmph101f -to 144000 -c miagcmph101_db_Trx_policy -s DB_Trx_Backup_no_Trunc -clnt miagcmph101 -FULL -kl 28 -b miagcmph101_1349213401 -jobid 12215 
05:30:06.653 [5160.6764] <4> bphdb: Module: libncf, Release: 7.5.0.3 , Build: 06/05/2012 20:00:00 CDT (20120605)
05:30:06.659 [5160.6764] <4> bphdb: Windows version: 6.1.7601, Platform: 2 (Service Pack 1), Service pack: 1.0, Suite: 272, Product type: 3
05:30:06.664 [5160.6764] <4> bphdb: Process architecture: 9, Page size: 4096, Process type: 2, Process level: 8664, Processor revision: 6
05:30:06.669 [5160.6764] <4> bphdb: Current code page: WINDOWS: 1252  (ANSI - Latin I), Max. character width: 1, Substitution character: 0x3F [?], Unicode substitution character: 0x003f [?.]
05:30:06.669 [5160.6764] <4> bphdb: INF - BACKUP START 5160
05:30:06.670 [5160.6764] <4> bphdb: INF - CONTINUE BACKUP message received
 
05:30:06.670 [5160.6764] <4> bphdb: INF - Processing C:\Program?Files\Veritas\NetBackup\DbExt\MsSql\miagcmph101_no_Trunc.bch
05:31:06.673 [5160.6764] <4> bphdb: INF - bphdb still working.
05:32:06.676 [5160.6764] <4> bphdb: INF - bphdb still working.
05:33:06.674 [5160.6764] <4> bphdb: INF - bphdb still working.
05:34:06.670 [5160.6764] <4> bphdb: INF - bphdb still working.
05:35:06.666 [5160.6764] <4> bphdb: INF - bphdb still working.
05:36:06.662 [5160.6764] <4> bphdb: INF - bphdb still working.
05:36:23.136 [5160.6764] <16> bphdb: ERR - command failed: the requested operation was partially successful (1)
05:36:23.136 [5160.6764] <4> bphdb: ERR - exit status  :  (1)
05:36:23.136 [5160.6764] <16> bphdb: ERR - bphdb exit status = 1: the requested operation was partially successful
 
05:36:23.136 [5160.6764] <4> bphdb: INF - EXIT STATUS 1: the requested operation was partially successful
 
06:30:06.558 [5936.3512] <2> logparams: -sb -rdbms sql_server -S msmbcmph101f -to 144000 -c miagcmph101_db_Trx_policy -s DB_Trx_Backup_no_Trunc -clnt miagcmph101 -FULL -kl 28 -b miagcmph101_1349217001 -jobid 12222 
06:30:06.575 [5936.3512] <4> bphdb: Module: libncf, Release: 7.5.0.3 , Build: 06/05/2012 20:00:00 CDT (20120605)
06:30:06.581 [5936.3512] <4> bphdb: Windows version: 6.1.7601, Platform: 2 (Service Pack 1), Service pack: 1.0, Suite: 272, Product type: 3
06:30:06.586 [5936.3512] <4> bphdb: Process architecture: 9, Page size: 4096, Process type: 2, Process level: 8664, Processor revision: 6
06:30:06.591 [5936.3512] <4> bphdb: Current code page: WINDOWS: 1252  (ANSI - Latin I), Max. character width: 1, Substitution character: 0x3F [?], Unicode substitution character: 0x003f [?.]
06:30:06.591 [5936.3512] <4> bphdb: INF - BACKUP START 5936
06:30:06.592 [5936.3512] <4> bphdb: INF - CONTINUE BACKUP message received
 
06:30:06.592 [5936.3512] <4> bphdb: INF - Processing C:\Program?Files\Veritas\NetBackup\DbExt\MsSql\miagcmph101_no_Trunc.bch
06:31:06.595 [5936.3512] <4> bphdb: INF - bphdb still working.
06:32:06.598 [5936.3512] <4> bphdb: INF - bphdb still working.
06:33:06.594 [5936.3512] <4> bphdb: INF - bphdb still working.
06:34:06.590 [5936.3512] <4> bphdb: INF - bphdb still working.
06:35:06.586 [5936.3512] <4> bphdb: INF - bphdb still working.
06:36:06.582 [5936.3512] <4> bphdb: INF - bphdb still working.
06:36:24.214 [5936.3512] <16> bphdb: ERR - command failed: the requested operation was partially successful (1)
06:36:24.214 [5936.3512] <4> bphdb: ERR - exit status  :  (1)
06:36:24.214 [5936.3512] <16> bphdb: ERR - bphdb exit status = 1: the requested operation was partially successful
 
06:36:24.214 [5936.3512] <4> bphdb: INF - EXIT STATUS 1: the requested operation was partially successful
 
07:30:06.772 [2796.7072] <2> logparams: -sb -rdbms sql_server -S msmbcmph101f -to 144000 -c miagcmph101_db_Trx_policy -s DB_Trx_Backup_no_Trunc -clnt miagcmph101 -FULL -kl 28 -b miagcmph101_1349220601 -jobid 12229 
07:30:06.825 [2796.7072] <4> bphdb: Module: libncf, Release: 7.5.0.3 , Build: 06/05/2012 20:00:00 CDT (20120605)
07:30:06.830 [2796.7072] <4> bphdb: Windows version: 6.1.7601, Platform: 2 (Service Pack 1), Service pack: 1.0, Suite: 272, Product type: 3
07:30:06.834 [2796.7072] <4> bphdb: Process architecture: 9, Page size: 4096, Process type: 2, Process level: 8664, Processor revision: 6
07:30:06.839 [2796.7072] <4> bphdb: Current code page: WINDOWS: 1252  (ANSI - Latin I), Max. character width: 1, Substitution character: 0x3F [?], Unicode substitution character: 0x003f [?.]
07:30:06.839 [2796.7072] <4> bphdb: INF - BACKUP START 2796
07:30:06.840 [2796.7072] <4> bphdb: INF - CONTINUE BACKUP message received
 
07:30:06.840 [2796.7072] <4> bphdb: INF - Processing C:\Program?Files\Veritas\NetBackup\DbExt\MsSql\miagcmph101_no_Trunc.bch
07:31:06.844 [2796.7072] <4> bphdb: INF - bphdb still working.
07:32:06.844 [2796.7072] <4> bphdb: INF - bphdb still working.
07:33:06.841 [2796.7072] <4> bphdb: INF - bphdb still working.
07:34:06.837 [2796.7072] <4> bphdb: INF - bphdb still working.
07:35:06.968 [2796.7072] <4> bphdb: INF - bphdb still working.
07:36:06.964 [2796.7072] <4> bphdb: INF - bphdb still working.
07:36:26.501 [2796.7072] <16> bphdb: ERR - command failed: the requested operation was partially successful (1)
07:36:26.501 [2796.7072] <4> bphdb: ERR - exit status  :  (1)
07:36:26.501 [2796.7072] <16> bphdb: ERR - bphdb exit status = 1: the requested operation was partially successful
 
07:36:26.501 [2796.7072] <4> bphdb: INF - EXIT STATUS 1: the requested operation was partially successful
 
08:30:06.655 [4764.6792] <2> logparams: -sb -rdbms sql_server -S msmbcmph101f -to 144000 -c miagcmph101_db_Trx_policy -s DB_Trx_Backup_no_Trunc -clnt miagcmph101 -FULL -kl 28 -b miagcmph101_1349224201 -jobid 12236 
08:30:06.672 [4764.6792] <4> bphdb: Module: libncf, Release: 7.5.0.3 , Build: 06/05/2012 20:00:00 CDT (20120605)
08:30:06.676 [4764.6792] <4> bphdb: Windows version: 6.1.7601, Platform: 2 (Service Pack 1), Service pack: 1.0, Suite: 272, Product type: 3
08:30:06.690 [4764.6792] <4> bphdb: Process architecture: 9, Page size: 4096, Process type: 2, Process level: 8664, Processor revision: 6
08:30:06.695 [4764.6792] <4> bphdb: Current code page: WINDOWS: 1252  (ANSI - Latin I), Max. character width: 1, Substitution character: 0x3F [?], Unicode substitution character: 0x003f [?.]
08:30:06.695 [4764.6792] <4> bphdb: INF - BACKUP START 4764
08:30:06.696 [4764.6792] <4> bphdb: INF - CONTINUE BACKUP message received
 
08:30:06.696 [4764.6792] <4> bphdb: INF - Processing C:\Program?Files\Veritas\NetBackup\DbExt\MsSql\miagcmph101_no_Trunc.bch
08:31:06.699 [4764.6792] <4> bphdb: INF - bphdb still working.
08:32:06.698 [4764.6792] <4> bphdb: INF - bphdb still working.
08:33:06.695 [4764.6792] <4> bphdb: INF - bphdb still working.
08:34:06.691 [4764.6792] <4> bphdb: INF - bphdb still working.
08:35:06.687 [4764.6792] <4> bphdb: INF - bphdb still working.
08:36:06.684 [4764.6792] <4> bphdb: INF - bphdb still working.
08:36:23.983 [4764.6792] <16> bphdb: ERR - command failed: the requested operation was partially successful (1)
08:36:23.983 [4764.6792] <4> bphdb: ERR - exit status  :  (1)
08:36:23.983 [4764.6792] <16> bphdb: ERR - bphdb exit status = 1: the requested operation was partially successful
 
08:36:23.983 [4764.6792] <4> bphdb: INF - EXIT STATUS 1: the requested operation was partially successful
 
09:30:06.623 [4776.7064] <2> logparams: -sb -rdbms sql_server -S msmbcmph101f -to 144000 -c miagcmph101_db_Trx_policy -s DB_Trx_Backup_no_Trunc -clnt miagcmph101 -FULL -kl 28 -b miagcmph101_1349227801 -jobid 12243 
09:30:06.637 [4776.7064] <4> bphdb: Module: libncf, Release: 7.5.0.3 , Build: 06/05/2012 20:00:00 CDT (20120605)
09:30:06.643 [4776.7064] <4> bphdb: Windows version: 6.1.7601, Platform: 2 (Service Pack 1), Service pack: 1.0, Suite: 272, Product type: 3
09:30:06.648 [4776.7064] <4> bphdb: Process architecture: 9, Page size: 4096, Process type: 2, Process level: 8664, Processor revision: 6
09:30:06.653 [4776.7064] <4> bphdb: Current code page: WINDOWS: 1252  (ANSI - Latin I), Max. character width: 1, Substitution character: 0x3F [?], Unicode substitution character: 0x003f [?.]
09:30:06.653 [4776.7064] <4> bphdb: INF - BACKUP START 4776
09:30:06.654 [4776.7064] <4> bphdb: INF - CONTINUE BACKUP message received
 
09:30:06.655 [4776.7064] <4> bphdb: INF - Processing C:\Program?Files\Veritas\NetBackup\DbExt\MsSql\miagcmph101_no_Trunc.bch
09:31:06.657 [4776.7064] <4> bphdb: INF - bphdb still working.
09:32:06.655 [4776.7064] <4> bphdb: INF - bphdb still working.
09:33:06.651 [4776.7064] <4> bphdb: INF - bphdb still working.
09:34:06.647 [4776.7064] <4> bphdb: INF - bphdb still working.
09:35:06.643 [4776.7064] <4> bphdb: INF - bphdb still working.
09:36:06.643 [4776.7064] <4> bphdb: INF - bphdb still working.
09:36:22.514 [4776.7064] <16> bphdb: ERR - command failed: the requested operation was partially successful (1)
09:36:22.514 [4776.7064] <4> bphdb: ERR - exit status  :  (1)
09:36:22.514 [4776.7064] <16> bphdb: ERR - bphdb exit status = 1: the requested operation was partially successful
 
09:36:22.514 [4776.7064] <4> bphdb: INF - EXIT STATUS 1: the requested operation was partially successful
 
10:30:06.463 [6032.1504] <2> logparams: -sb -rdbms sql_server -S msmbcmph101f -to 144000 -c miagcmph101_db_Trx_policy -s DB_Trx_Backup_no_Trunc -clnt miagcmph101 -FULL -kl 28 -b miagcmph101_1349231401 -jobid 12250 
10:30:06.478 [6032.1504] <4> bphdb: Module: libncf, Release: 7.5.0.3 , Build: 06/05/2012 20:00:00 CDT (20120605)
10:30:06.483 [6032.1504] <4> bphdb: Windows version: 6.1.7601, Platform: 2 (Service Pack 1), Service pack: 1.0, Suite: 272, Product type: 3
10:30:06.488 [6032.1504] <4> bphdb: Process architecture: 9, Page size: 4096, Process type: 2, Process level: 8664, Processor revision: 6
10:30:06.493 [6032.1504] <4> bphdb: Current code page: WINDOWS: 1252  (ANSI - Latin I), Max. character width: 1, Substitution character: 0x3F [?], Unicode substitution character: 0x003f [?.]
10:30:06.493 [6032.1504] <4> bphdb: INF - BACKUP START 6032
10:30:06.544 [6032.1504] <4> bphdb: INF - CONTINUE BACKUP message received
 
10:30:06.544 [6032.1504] <4> bphdb: INF - Processing C:\Program?Files\Veritas\NetBackup\DbExt\MsSql\miagcmph101_no_Trunc.bch
10:31:06.547 [6032.1504] <4> bphdb: INF - bphdb still working.
10:32:06.543 [6032.1504] <4> bphdb: INF - bphdb still working.
10:33:06.539 [6032.1504] <4> bphdb: INF - bphdb still working.
10:34:06.535 [6032.1504] <4> bphdb: INF - bphdb still working.
10:35:06.532 [6032.1504] <4> bphdb: INF - bphdb still working.
10:36:06.532 [6032.1504] <4> bphdb: INF - bphdb still working.
10:36:23.192 [6032.1504] <16> bphdb: ERR - command failed: the requested operation was partially successful (1)
10:36:23.192 [6032.1504] <4> bphdb: ERR - exit status  :  (1)
10:36:23.192 [6032.1504] <16> bphdb: ERR - bphdb exit status = 1: the requested operation was partially successful
 
10:36:23.192 [6032.1504] <4> bphdb: INF - EXIT STATUS 1: the requested operation was partially successful
 
11:30:06.784 [5744.6372] <2> logparams: -sb -rdbms sql_server -S msmbcmph101f -to 144000 -c miagcmph101_db_Trx_policy -s DB_Trx_Backup_no_Trunc -clnt miagcmph101 -FULL -kl 28 -b miagcmph101_1349235001 -jobid 12257 
11:30:06.799 [5744.6372] <4> bphdb: Module: libncf, Release: 7.5.0.3 , Build: 06/05/2012 20:00:00 CDT (20120605)
11:30:06.805 [5744.6372] <4> bphdb: Windows version: 6.1.7601, Platform: 2 (Service Pack 1), Service pack: 1.0, Suite: 272, Product type: 3
11:30:06.810 [5744.6372] <4> bphdb: Process architecture: 9, Page size: 4096, Process type: 2, Process level: 8664, Processor revision: 6
11:30:06.815 [5744.6372] <4> bphdb: Current code page: WINDOWS: 1252  (ANSI - Latin I), Max. character width: 1, Substitution character: 0x3F [?], Unicode substitution character: 0x003f [?.]
11:30:06.815 [5744.6372] <4> bphdb: INF - BACKUP START 5744
11:30:06.816 [5744.6372] <4> bphdb: INF - CONTINUE BACKUP message received
 
11:30:06.816 [5744.6372] <4> bphdb: INF - Processing C:\Program?Files\Veritas\NetBackup\DbExt\MsSql\miagcmph101_no_Trunc.bch
11:31:06.817 [5744.6372] <4> bphdb: INF - bphdb still working.
11:32:06.813 [5744.6372] <4> bphdb: INF - bphdb still working.
11:33:06.809 [5744.6372] <4> bphdb: INF - bphdb still working.
11:34:06.805 [5744.6372] <4> bphdb: INF - bphdb still working.
11:35:06.802 [5744.6372] <4> bphdb: INF - bphdb still working.
11:36:06.808 [5744.6372] <4> bphdb: INF - bphdb still working.
11:36:23.100 [5744.6372] <16> bphdb: ERR - command failed: the requested operation was partially successful (1)
11:36:23.100 [5744.6372] <4> bphdb: ERR - exit status  :  (1)
11:36:23.100 [5744.6372] <16> bphdb: ERR - bphdb exit status = 1: the requested operation was partially successful
 
11:36:23.100 [5744.6372] <4> bphdb: INF - EXIT STATUS 1: the requested operation was partially successful
 
12:11:55.227 [4036.3800] <2> logparams: -sb -rdbms sql_server -S msmbcmph101f -to 144000 -c miagcmph101_db_Trx_policy -s DB_Trx_Backup_no_Trunc -clnt miagcmph101 -FULL -kl 28 -b miagcmph101_1349237509 -jobid 12264 
12:11:55.241 [4036.3800] <4> bphdb: Module: libncf, Release: 7.5.0.3 , Build: 06/05/2012 20:00:00 CDT (20120605)
12:11:55.246 [4036.3800] <4> bphdb: Windows version: 6.1.7601, Platform: 2 (Service Pack 1), Service pack: 1.0, Suite: 272, Product type: 3
12:11:55.251 [4036.3800] <4> bphdb: Process architecture: 9, Page size: 4096, Process type: 2, Process level: 8664, Processor revision: 6
12:11:55.256 [4036.3800] <4> bphdb: Current code page: WINDOWS: 1252  (ANSI - Latin I), Max. character width: 1, Substitution character: 0x3F [?], Unicode substitution character: 0x003f [?.]
12:11:55.256 [4036.3800] <4> bphdb: INF - BACKUP START 4036
12:11:55.256 [4036.3800] <4> bphdb: INF - CONTINUE BACKUP message received
 
12:11:55.257 [4036.3800] <4> bphdb: INF - Processing C:\Program?Files\Veritas\NetBackup\DbExt\MsSql\miagcmph101_no_Trunc.bch
12:12:55.259 [4036.3800] <4> bphdb: INF - bphdb still working.
12:13:55.259 [4036.3800] <4> bphdb: INF - bphdb still working.
12:14:55.255 [4036.3800] <4> bphdb: INF - bphdb still working.
12:15:55.309 [4036.3800] <4> bphdb: INF - bphdb still working.
12:16:55.305 [4036.3800] <4> bphdb: INF - bphdb still working.
12:17:55.302 [4036.3800] <4> bphdb: INF - bphdb still working.
12:18:09.082 [4036.3800] <16> bphdb: ERR - command failed: the requested operation was partially successful (1)
12:18:09.082 [4036.3800] <4> bphdb: ERR - exit status  :  (1)
12:18:09.082 [4036.3800] <16> bphdb: ERR - bphdb exit status = 1: the requested operation was partially successful
 
12:18:09.082 [4036.3800] <4> bphdb: INF - EXIT STATUS 1: the requested operation was partially successful
 
13:11:54.428 [4624.3584] <2> logparams: -sb -rdbms sql_server -S msmbcmph101f -to 144000 -c miagcmph101_db_Trx_policy -s DB_Trx_Backup_no_Trunc -clnt miagcmph101 -FULL -kl 28 -b miagcmph101_1349241109 -jobid 12272 
13:11:54.443 [4624.3584] <4> bphdb: Module: libncf, Release: 7.5.0.3 , Build: 06/05/2012 20:00:00 CDT (20120605)
13:11:54.448 [4624.3584] <4> bphdb: Windows version: 6.1.7601, Platform: 2 (Service Pack 1), Service pack: 1.0, Suite: 272, Product type: 3
13:11:54.453 [4624.3584] <4> bphdb: Process architecture: 9, Page size: 4096, Process type: 2, Process level: 8664, Processor revision: 6
13:11:54.457 [4624.3584] <4> bphdb: Current code page: WINDOWS: 1252  (ANSI - Latin I), Max. character width: 1, Substitution character: 0x3F [?], Unicode substitution character: 0x003f [?.]
13:11:54.457 [4624.3584] <4> bphdb: INF - BACKUP START 4624
13:11:54.458 [4624.3584] <4> bphdb: INF - CONTINUE BACKUP message received
 
13:11:54.459 [4624.3584] <4> bphdb: INF - Processing C:\Program?Files\Veritas\NetBackup\DbExt\MsSql\miagcmph101_no_Trunc.bch
13:12:54.462 [4624.3584] <4> bphdb: INF - bphdb still working.
13:13:54.460 [4624.3584] <4> bphdb: INF - bphdb still working.
13:14:54.456 [4624.3584] <4> bphdb: INF - bphdb still working.
13:15:54.452 [4624.3584] <4> bphdb: INF - bphdb still working.
13:16:54.448 [4624.3584] <4> bphdb: INF - bphdb still working.
13:17:54.447 [4624.3584] <4> bphdb: INF - bphdb still working.
13:18:08.297 [4624.3584] <16> bphdb: ERR - command failed: the requested operation was partially successful (1)
13:18:08.297 [4624.3584] <4> bphdb: ERR - exit status  :  (1)
13:18:08.297 [4624.3584] <16> bphdb: ERR - bphdb exit status = 1: the requested operation was partially successful
 
13:18:08.297 [4624.3584] <4> bphdb: INF - EXIT STATUS 1: the requested operation was partially successful
 
13:25:49.826 [5964.6280] <2> logparams: -sb -rdbms sql_server -S msmbcmph101f -to 144000 -c miagcmph101_db_Trx_policy -s DB_Trx_Backup_no_Trunc -clnt miagcmph101 -FULL -kl 28 -b miagcmph101_1349241944 -jobid 12274 
13:25:49.840 [5964.6280] <4> bphdb: Module: libncf, Release: 7.5.0.3 , Build: 06/05/2012 20:00:00 CDT (20120605)
13:25:49.844 [5964.6280] <4> bphdb: Windows version: 6.1.7601, Platform: 2 (Service Pack 1), Service pack: 1.0, Suite: 272, Product type: 3
13:25:49.849 [5964.6280] <4> bphdb: Process architecture: 9, Page size: 4096, Process type: 2, Process level: 8664, Processor revision: 6
13:25:49.853 [5964.6280] <4> bphdb: Current code page: WINDOWS: 1252  (ANSI - Latin I), Max. character width: 1, Substitution character: 0x3F [?], Unicode substitution character: 0x003f [?.]
13:25:49.853 [5964.6280] <4> bphdb: INF - BACKUP START 5964
13:25:49.855 [5964.6280] <4> bphdb: INF - CONTINUE BACKUP message received
 
13:25:49.855 [5964.6280] <4> bphdb: INF - Processing C:\Program?Files\Veritas\NetBackup\DbExt\MsSql\miagcmph101_no_Truncate.bch
13:26:49.858 [5964.6280] <4> bphdb: INF - bphdb still working.
13:27:49.860 [5964.6280] <4> bphdb: INF - bphdb still working.
13:28:49.863 [5964.6280] <4> bphdb: INF - bphdb still working.
13:29:49.865 [5964.6280] <4> bphdb: INF - bphdb still working.
13:30:49.864 [5964.6280] <4> bphdb: INF - bphdb still working.
13:31:49.860 [5964.6280] <4> bphdb: INF - bphdb still working.
13:32:02.516 [5964.6280] <16> bphdb: ERR - command failed: the requested operation was partially successful (1)
13:32:02.516 [5964.6280] <4> bphdb: ERR - exit status  :  (1)
13:32:02.516 [5964.6280] <16> bphdb: ERR - bphdb exit status = 1: the requested operation was partially successful
 
13:32:02.516 [5964.6280] <4> bphdb: INF - EXIT STATUS 1: the requested operation was partially successful
 

Comments 4 CommentsJump to latest comment

Marianne's picture

Looks like this script is failing:

C:\Program Files\Veritas\NetBackup\DbExt\MsSql\miagcmph101_no_Trunc.bch

Please ensure that dbclient log folder exists on the client, 
Post dbclient log, SQL progress log (in  C:\Program Files\veritas\netbackup\logs\user_ops\mssql\logs) as well as the script.

Please rename logs to reflect process name (e.g. dbclient.txt) and post as File attachments.

 

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Yasuhisa Ishikawa's picture

Is this new setup? Or does it work successfuly until you got this error?

Please paste job detail in Activity Monitor.

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

Mark_Solutions's picture

Also check under \netbackup\logs\mssql_backup_failures\ as errors get posted there

Please add logs as attachments rather than pasting them into the thread to make it easier to read through the thread

Thanks

Authorised Symantec Consultant

Don't forget to "Mark as Solution" if someones advice has solved your issue - and please bring back the Thumbs Up!!.

itsmeLuck's picture

@Yasuhisa Ishikawa this was all working fine until this happened. 

Mark_Solutions  I can't find the logs that wanted me to look in.

@Marianne van den Berg  I tried creating a new script with the same instances however it shows same error.

 

Thank you, hope we can fix this ASAP.