- 论坛徽章:
- 0
|
master server是工作组计算机 client在域里 执行步骤：
1、2台机器互相加HOST，能机器名PING通；
2、SERVER远程推送CLIENT到客户端。。。；
3、配置Netbackup Agent，SQL SERVER CONNECTION PROPERTIES:HOST匹配，访问数据库用户名：administrator 密码：***** 然后Apply 成功，无错误信息（用户名为域管理员和本机管理员权限）。
4、Backup Sql Objects设置，选择要备份的2个库。。。选FULL备份 。。SAVE打点。。。点BACKUP，弹出对话框，保存和检查BCK.BCH文件 我生成新文件123.BCH
5、MASTER SERVER建策略 策略名。。。机器名。。。客户端类型：PC，windows 2003 server，数据类型 MS-SQL-SERVER 。自动备份。。。选择文件路径并指定客户机上的123.BCH文件。每天23点-2点一备份，一周一循环。。创建策略完成，双机策略选择介质。。。为MASTER SERVER本地磁盘G上的文件夹（该文件夹一加入介质池，备份其他数据无任何问题，包括其他SQL数据库）。。。
6、手动备份。。。小绿人开始跑动。。。大红叉。。错误239。。。
检查错误：
备份时，SQL server日志：
1、BackupMedium::ReportIoError: 在备份设备“VNBU0-4680-5680-1276224197”上 write 失败。操作系统错误 995(由于线程退出或应用程序请求，已放弃 I/O 操作。)。
2、Internal I/O request 0x276A3B60: Op: Write, pBuffer: 0x087F0000, Size: 65536, Position: 0, UMS: Internal: 0x2776A038, InternalHigh: 0x2622BF68, Offset: 0x2622BEE8, OffsetHigh: 0x2622BE68, m_buf: 0x2622BC68, m_len: 639810536, m_actualBytes: 0, m_errcode: 995, BackupFile: VNBU0-4680-5680-1276224197
3、BACKUP 未能完成命令 backup database "qyspf" to VIRTUAL_DEVICE='VNBU0-4680-5680-1276224197' with blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
4、BackupVirtualDeviceFile::RequestDurableMedia: 在备份设备“VNBU0-4680-5680-1276224197”上 Flush 失败。操作系统错误 995(由于线程退出或应用程序请求，已放弃 I/O 操作。)。
5、BackupMedium::ReportIoError: 在备份设备“VNBU0-4680-4652-1276224228”上 write 失败。操作系统错误 995(由于线程退出或应用程序请求，已放弃 I/O 操作。)。
6、BACKUP 未能完成命令 backup database "ylqx" to VIRTUAL_DEVICE='VNBU0-4680-4652-1276224228' with blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
7、Internal I/O request 0x27D81B68: Op: Write, pBuffer: 0x087F0000, Size: 65536, Position: 0, UMS: Internal: 0xC, InternalHigh: 0x0, Offset: 0x0, OffsetHigh: 0x27EA6C00, m_buf: 0x27EA6400, m_len: 668470272, m_actualBytes: 0, m_errcode: 995, BackupFile: VNBU0-4680-4652-1276224228
8、BackupVirtualDeviceFile::RequestDurableMedia: 在备份设备“VNBU0-4680-4652-1276224228”上 Flush 失败。操作系统错误 995(由于线程退出或应用程序请求，已放弃 I/O 操作。)。
CLIENT端SQL SERVER CONNECTION PROPERTIES，VIEW STATUS：
GROUPSIZE 2
OPERATION BACKUP
DATABASE "qyspf"
SQLHOST "pfserver2"
NBSERVER "QYSYYDL1"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "ylqx"
SQLHOST "pfserver2"
NBSERVER "QYSYYDL1"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
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 1)
Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\bkup.bch, Op# = 1
INF - Using backup image pfserver2.MSSQL7.PFSERVER2.db.qyspf.~.7.001of001.20100611104317..C
INF - backup database "qyspf" to VIRTUAL_DEVICE='VNBU0-4680-5680-1276224197' with blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <pfserver2>. Connection timeout is <300> seconds.
Backup started Fri Jun 11 10:43:18 2010
ERR - Error in VxBSACreateObject: 3.
CONTINUATION: - System detected error, operation aborted.
ERR - Error in GetCommand: 0x80770004.
CONTINUATION: - An abort request is preventing anything except termination actions.
ERR - Error in VDS->Close: 0x80770004.
CONTINUATION: - An abort request is preventing anything except termination actions.
INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\bkup.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 28(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 1)
Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\bkup.bch, Op# = 2
INF - Using backup image pfserver2.MSSQL7.PFSERVER2.db.ylqx.~.7.001of001.20100611104348..C
INF - backup database "ylqx" to VIRTUAL_DEVICE='VNBU0-4680-4652-1276224228' with blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
INF - Number of stripes: 1, Number of buffers per stripe 2.
INF - Created VDI object for SQL Server instance <pfserver2>. Connection timeout is <300> seconds.
10:43:59.718 [4680.5556] <4> : 10:43:54 INF - Server status = 239
ERR - Error in VxBSACreateObject: 3.
CONTINUATION: - System detected error, operation aborted.
ERR - Error in GetCommand: 0x80770004.
CONTINUATION: - An abort request is preventing anything except termination actions.
ERR - Error in VDS->Close: 0x80770004.
CONTINUATION: - An abort request is preventing anything except termination actions.
INF - OPERATION #2 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\bkup.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 18(0) seconds.
INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\bkup.bch>:
<0> operations succeeded. <2> operations failed.
INF - The following object(s) were not backed up successfully.
INF - qyspf
INF - ylqx
请高手帮忙解决下，看看到底是什么原因？ |
|
免费注册
发表于 2011-03-23 17:01
