现象描述:
sybase的dump备份备份不了,
环境:win 2k ase115,
d:\sybase为装sybase的目录
查看d:\sybase\install\errorlog,和backup.log,有错误,with error number 109 (管道已结束?. Refer to your operating system documentation for further details.
使用bat备份时(因为sqladv.exe也用不了,提示:非法的win32程序),现象如下:
Microsoft Windows 2000 [Version 5.00.2195]
(C) 版权所有 1985-2000 Microsoft Corp.
C:\Documents and Settings\Administrator>H:
H:\>cd backup
H:\backup>cd 3
H:\backup\3>backup.bat
H:\backup\3>d:\sybase\bin\isql -Usa -P -ih:\backup\3\backup.sql
拒绝访问。
H:\backup\3>backup.bat
H:\backup\3>d:\sybase\bin\isql -Usa -P -ih:\backup\3\backup.sql
Backup Server session id is: 5. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 4.142.2.74: [0] The 'GetBinaryType' call failed with error number
193 (Cannot get operating system error tex). Refer to your operating system
documentation for further details.
Backup Server: 4.133.2.1: Invalid path or no execute permission for
multibuffering subprocess binary: d:\sybase\bin\sybmbuf.exe
Msg 8009, Level 16, State 1:
Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages for
details.
解决方法:
找一个机器,装一个ase115的客户端,此机器会形成D:\Sybase\bin\的文件夹,此文件夹下面有三个exe文件,是执行dump database 命令所必须要的。sybmbuf.exe
isql.exe
sqladv.exe
当然了,还有其他的exe文件是运行sybase所必须的,这里不再一一列出,可能是病毒感染时,因为sybase 服务正在使用这些文件,病毒没有感染成功。
将以上三个exe文件复制到服务器上的d:\sybase\bin\目录里,再执行bat,就没有问题了
H:\backup\3>backup.bat
H:\backup\3>d:\sybase\bin\isql -Usa -P -ih:\backup\3\backup.sql
Backup Server session id is: 8. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name 'cwbase6083590E9D2' section number 0001
mounted on disk file 'h:\backup\3\cwbase6.dup'
Backup Server: 4.58.1.1: Database cwbase6: 32056 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 109844 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 145816 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 186482 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 214776 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 236230 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 256524 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 285088 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 348304 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 415228 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 450010 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 460482 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 494502 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 528268 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 558818 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 567764 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 592674 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 628744 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 674476 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 692638 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 713840 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 753146 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 767166 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 792382 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database cwbase6: 822416 kilobytes DUMPed.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/161195/viewspace-521149/ ,如需转载,请注明出处,否则将追究法律责任。