du_du_wolf

使用veritas备份一个网站服务器的sql数据库时出现下列错误，请大家帮忙分析下
2008-4-1 1:00:00 - requesting resource mail
2008-4-1 1:00:00 - requesting resource veritasbkserv.NBU_CLIENT.MAXJOBS.jn-web
2008-4-1 1:00:00 - requesting resource veritasbkserv.NBU_POLICY.MAXJOBS.WangZ_SQL_CYBK
2008-4-1 1:00:00 - granted resource veritasbkserv.NBU_CLIENT.MAXJOBS.jn-web
2008-4-1 1:00:00 - granted resource veritasbkserv.NBU_POLICY.MAXJOBS.WangZ_SQL_CYBK
2008-4-1 1:00:00 - granted resource UFE185
2008-4-1 1:00:00 - granted resource IBM.ULTRIUM-TD2.001
2008-4-1 1:00:00 - granted resource mail
2008-4-1 1:00:02 - started process bpbrm (5804)
2008-4-1 1:00:02 - connecting
2008-4-1 1:00:03 - connected; connect time: 00:00:01
2008-4-1 1:03:39 - end writing
the requested operation was partially successful(1)
The job was successfully completed, but some files may have been
busy or unaccessible. See the problems report or the client's logs for more details.

[ 本帖最后由 du_du_wolf 于 2008-4-1 08:44 编辑 ]

du_du_wolf

客户端bphdb日志
00:59:13.796 [5536.7296] <2> logparams: -sb -rdbms sql_server -S veritasbkserv -to 300 -c WangZ_SQL_CYBK -s chayibkweb -clnt jn-web -FULL -b jn-web_1206982800 -jobid 2709
00:59:13.796 [5536.7296] <2> ParseConfigExA: Unknown configuration option on line 51: RenameIfExists = 1
00:59:13.796 [5536.7296] <4> bphdb sync_server: INF - BACKUP START
00:59:13.796 [5536.7296] <4> bphdb sync_server: INF - CONTINUE BACKUP message received.
00:59:13.812 [5536.7296] <2> bphdb get_filelist: INF - Read filename: <E:\veritas-scripts\chayisql.bch>
00:59:13.812 [5536.7296] <2> bphdb get_filelist: INF - Read filename: <CONTINUE>
00:59:13.812 [5536.7296] <4> bphdb.do_launch_ex: INF - Processing E
01:00:13.843 [5536.7296] <4> bphdb.CreateProcessForNT: INF - bphdb still working.
01:01:13.843 [5536.7296] <4> bphdb.CreateProcessForNT: INF - bphdb still working.
01:02:13.843 [5536.7296] <4> bphdb.CreateProcessForNT: INF - bphdb still working.
01:02:47.265 [5536.7296] <16> bphdb.CreateProcessForNT: ERR - command failed: the requested operation was partially successful (1)
01:02:47.265 [5536.7296] <4> bphdb.do_launch_ex: ERR - exit status  :  (1)
01:02:47.265 [5536.7296] <16> bphdb Exit: ERR - bphdb exit status = 1: the requested operation was partially successful
01:02:47.265 [5536.7296] <4> bphdb Exit: INF - EXIT STATUS 1: the requested operation was partially successful

[ 本帖最后由 du_du_wolf 于 2008-4-1 08:45 编辑 ]

du_du_wolf

客户端的日志查看
GROUPSIZE 3
OPERATION BACKUP
DATABASE "generalweb"
SQLHOST "JN"
NBSERVER "VERITASBKSERV"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
DUMPOPTION INCREMENTAL
ENDOPER TRUE
OPERATION BACKUP
DATABASE "master"
SQLHOST "JN"
NBSERVER "VERITASBKSERV"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
DUMPOPTION INCREMENTAL
ENDOPER TRUE
OPERATION BACKUP
DATABASE "yjmatch"
SQLHOST "JN"
NBSERVER "VERITASBKSERV"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
DUMPOPTION INCREMENTAL
ENDOPER TRUE


INF - BACKUP STARTED USING
Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)
May  3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Batch = E:veritas-scriptschayisql.bch, Op# = 1
INF - Using backup image jn.MSSQL7.JN.inc.generalweb.~.7.001of001.20080401005915..C
INF - backup database "generalweb" to VIRTUAL_DEVICE='VNBU0-6768-6700-1206982755' with blocksize = 65536, maxtransfersize = 65536, buffercount = 1, differential
INF - Number of stripes: 1, Number of buffers per stripe 1.
INF - Created VDI object for SQL Server instance <JN>. Connection timeout is <300> seconds.
Backup started Tue Apr 01 00:59:16 2008


00:59:22 Initiating backup
00:59:26 INF - Data socket = veritasbkserv.IPC:56755;fe30758f31e4953619674f884ca1294e;4;300
00:59:26 INF - Starting bpbrm

00:59:26 INF - Name socket = veritasbkserv.IPC:56756;ba83ab0eac8fdf7a14c97341360f4cf1;4;300
00:59:27 INF - Job id = 2710
00:59:27 INF - Backup id = jn_1206982812
00:59:27 INF - Backup time = 1206982812
00:59:27 INF - Policy name = WangZ_SQL_CYBK
00:59:28 INF - Snapshot = 0
00:59:28 INF - Frozen image = 0
00:59:28 INF - Backup copy = 0
00:59:28 INF - Master server = veritasbkserv
00:59:29 INF - Media server = veritasbkserv
00:59:29 INF - Multiplexing = 0
00:59:29 INF - New data socket = veritasbkserv.IPC:56753;44d846c78dc4b08b06ebe4748ed69c9e;4;300
00:59:29 INF - Use shared memory = 0
00:59:29 INF - Compression = 0
00:59:30 INF - Encrypt = 0
00:59:30 INF - Client read timeout = 300
00:59:30 INF - Media mount timeout = 0
00:59:37 INF - Data buffer size = 65536
01:01:21 INF - Beginning backup on server veritasbkserv of client jn
INF - Thread has been closed for stripe #0
01:01:32 INF - Server status = 0
01:01:34 INF - Backup by administrator on client jn using policy WangZ_SQL_CYBK, sched Default-Application-Backup:the requested operation was successfully completed.


INF - OPERATION #1 of batch E:veritas-scriptschayisql.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 143(0) seconds
USER - Operation inhibited by NetBackup for Microsoft SQL Server: Only a full backup can be performed on the master database.
INF - OPERATION #2 of batch E:veritas-scriptschayisql.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 5(0) seconds.
INF - BACKUP STARTED USING
Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)
May  3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Batch = E:veritas-scriptschayisql.bch, Op# = 3
INF - Using backup image jn.MSSQL7.JN.inc.yjmatch.~.7.001of001.20080401010147..C
INF - backup database "yjmatch" to VIRTUAL_DEVICE='VNBU0-6768-6828-1206982907' with blocksize = 65536, maxtransfersize = 65536, buffercount = 1, differential
INF - Number of stripes: 1, Number of buffers per stripe 1.
INF - Created VDI object for SQL Server instance <JN>. Connection timeout is <300> seconds.
INF - Thread has been closed for stripe #0
INF - OPERATION #3 of batch E:veritas-scriptschayisql.bch SUCCEEDED with STATUS 0 (0 is normal). Elapsed time = 38(0) seconds
INF - Results of executing <E:veritas-scriptschayisql.bch>:
<2> operations succeeded. <1> operations failed.