sybase ase 無法備份(backup.log中,提示with error number 109 )

現象描述：

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.