NBU备份SQL2005

lzx313

麻烦各位神仙给把把关啊，错误信息如下，但是我没有找到问题原因.

8:34:03 - Info nbjm(pid=1116) starting backup job (jobid=12 for client view, policy viewt, schedule Full  
2012-2-9 8:34:03 - Info nbjm(pid=1116) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=128, request id:{6B067F66-1643-4E78-B1C6-AF2FA8EA154D})  
2012-2-9 8:34:03 - requesting resource disk
2012-2-9 8:34:03 - requesting resource wvimat.NBU_CLIENT.MAXJOBS.view
2012-2-9 8:34:03 - requesting resource wvimat.NBU_POLICY.MAXJOBS.viewt
2012-2-9 8:34:03 - granted resource wvimat.NBU_CLIENT.MAXJOBS.view
2012-2-9 8:34:03 - granted resource wvimat.NBU_POLICY.MAXJOBS.viewt
2012-2-9 8:34:03 - granted resource disk
2012-2-9 8:34:03 - estimated 0 Kbytes needed
2012-2-9 8:34:03 - Info nbjm(pid=1116) started backup job for client view, policy viewt, schedule Full on storage unit disk
2012-2-9 8:34:03 - started process bpbrm (242
2012-2-9 8:34:04 - Info bpbrm(pid=242 view is the host to backup data from     
2012-2-9 8:34:04 - Info bpbrm(pid=242 reading file list from client        
2012-2-9 8:34:04 - connecting
2012-2-9 8:34:06 - Info bpbrm(pid=242 starting bphdb on client         
2012-2-9 8:34:06 - connected; connect time: 00:00:02
2012-2-9 8:34:07 - Info bphdb(pid=2312) Backup started           
2012-2-9 8:34:09 - Info dbclient(pid=3212) INF - BACKUP STARTED USING        
2012-2-9 8:34:09 - Info dbclient(pid=3212) Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)     
2012-2-9 8:34:09 - Info dbclient(pid=3212) Oct 14 2005 00:33:37         
2012-2-9 8:34:09 - Info dbclient(pid=3212) Copyright (c) 1988-2005 Microsoft Corporation        
2012-2-9 8:34:09 - Info dbclient(pid=3212) Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)  
2012-2-9 8:34:09 - Info dbclient(pid=3212) Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\viewt.bch, Op# = 1      
2012-2-9 8:34:10 - Info dbclient(pid=3212) INF - Using backup image view.MSSQL7.VIEW\VIEWSP.db.viewt.~.7.001of001.20120209083505..C      
2012-2-9 8:34:10 - Info dbclient(pid=3212) INF - backup database "viewt" to VIRTUAL_DEVICE='VNBU0-3212-4888-1328747707' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
2012-2-9 8:34:10 - Info dbclient(pid=3212) INF - Number of stripes: 1, Number of buffers per stripe 2.
2012-2-9 8:34:10 - Info dbclient(pid=3212) INF - Created VDI object for SQL Server instance <VIEWSP>. Connection timeout is <300> seconds.
2012-2-9 8:49:22 - Info dbclient(pid=3212) ERR - Error in VxBSACreateObject: 3.      
2012-2-9 8:49:22 - Info dbclient(pid=3212)     CONTINUATION: - System detected error, operation aborted.  
2012-2-9 8:49:22 - Info dbclient(pid=3212) ERR - Error in GetCommand: 0x80770004.      
2012-2-9 8:49:22 - Info dbclient(pid=3212)     CONTINUATION: - An abort request is preventing anything except termination actions.
2012-2-9 8:49:22 - Info dbclient(pid=3212) DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3202><[Microsoft][SQL Native Client][SQL Server]在 "VNBU0-3212-4888-1328747707" 上写入失败: 995(由于线程退出或应用程序请求，已放弃 I/O 操作。)>.
2012-2-9 8:49:23 - Info dbclient(pid=3212) DBMS MSG - SQL Message <3271><[Microsoft][SQL Native Client][SQL Server]在文件 "VNBU0-3212-4888-1328747707" 上发生不可恢复的 I/O 错误: 995(由于线程退出或应用程序请求，已放弃 I/O 操作。)。>
2012-2-9 8:49:23 - Info dbclient(pid=3212) DBMS MSG - SQL Message <3013><[Microsoft][SQL Native Client][SQL Server]BACKUP DATABASE 正在异常终止。>  
2012-2-9 8:49:23 - Info dbclient(pid=3212) ERR - Error found executing <backup database "viewt" to VIRTUAL_DEVICE='VNBU0-3212-4888-1328747707' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.
2012-2-9 8:54:24 - Info dbclient(pid=3212) ERR - Error in VDS->Close: 0x80770004.      
2012-2-9 8:54:24 - Info dbclient(pid=3212)     CONTINUATION: - An abort request is preventing anything except termination actions.
2012-2-9 8:54:24 - Info dbclient(pid=3212) INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\viewt.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 1216(1216) seconds.
2012-2-9 8:54:26 - Info dbclient(pid=3212) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\viewt.bch>:      
2012-2-9 8:54:26 - Info dbclient(pid=3212) <0> operations succeeded. <1> operations failed.      
2012-2-9 8:54:26 - Info dbclient(pid=3212) INF - The following object(s) were not backed up successfully.   
2012-2-9 8:54:26 - Info dbclient(pid=3212) INF - viewt         
2012-2-9 8:54:26 - Error bpbrm(pid=242 from client view: ERR - command failed: none of the requested files were backed up (2)
2012-2-9 8:54:26 - Error bpbrm(pid=242 from client view: ERR - bphdb exit status = 2: none of the requested files were backed up
2012-2-9 8:54:28 - end writing
none of the requested files were backed up(2)

lzx313

26个人呢浏览 木有一个人给回答

lzx313

2012-2-9 10:28:11 - Info dbclient(pid=5536) Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)     
2012-2-9 10:28:11 - Info dbclient(pid=5536) Oct 14 2005 00:33:37         
2012-2-9 10:28:11 - Info dbclient(pid=5536) Copyright (c) 1988-2005 Microsoft Corporation        
2012-2-9 10:28:11 - Info dbclient(pid=5536) Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)  
2012-2-9 10:28:11 - Info dbclient(pid=5536) Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\mnmn.bch, Op# = 1      
2012-2-9 10:28:11 - Info dbclient(pid=5536) INF - Using backup image view.MSSQL7.VIEW\VIEWSP.db.mnmn.~.7.001of001.20120209102907..C      
2012-2-9 10:28:11 - Info dbclient(pid=5536) INF - backup database "mnmn" to VIRTUAL_DEVICE='VNBU0-5536-5464-1328754548' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
2012-2-9 10:28:11 - Info dbclient(pid=5536) INF - Number of stripes: 1, Number of buffers per stripe 2.
2012-2-9 10:28:12 - Info dbclient(pid=5536) INF - Created VDI object for SQL Server instance <VIEWSP>. Connection timeout is <300> seconds.

lzx313

本地备份 也是失败的

fastester

回复 1# lzx313


       看看dbclient等的日志吧，管理手册上有指出创建哪些目录的。
  
     另外如果是64bit OS装32bit SQL，检查一下32bit和64bit路径下的sqlvdi.dll的版本是否一致。

http://hi.baidu.com/li_zhonghui/ ... f8811b3bf3cfa2.html

无牙

windows什么版本？

lzx313

多谢各位大虾，应该是补丁包的原因。更新后重新安装就解决了。 多谢各位！

无牙