【求助】数据库备份不完整

zyeline

晚上自动调用bat文件进行备份，内容如下：
isql -Usa -P -Spyserver <dumpdb.sql>; mesg-dumpdb.txt

dumpdb.sql内容如下：
use pydb
go
dump database pydb to 'd:\pydb.dmp'
go

这个应该没有问题，备份执行完毕后，早上检查发现数据库备份不完整，正确备份文件大小应有5G多点，现在只有3G多点，errorlog日志如下：
00:00000:00013:2004/02/25 05:07:11.75 kernel  Cannot send, host process disconnected: PYSERVER 2644 spid: 13
00:00000:00013:2004/02/25 05:07:11.80 server  Error: 1608, Severity: 18, State: 4
00:00000:00013:2004/02/25 05:07:11.80 server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.

那位好心人帮忙看下是什么问题，这两天sybase老出问题，真是头大。

小无赖

isql -Spyserver  -Usa -P -i c:\dumpdb.sql -o c:\dumpdb.txt

zyeline

这两个参数和'<' '>;'符号的作用是一样的吧。

小无赖

那我不知道，我知道-i在NT下肯定没问题。

zyeline

试过了，不是这两个参数原因。

RS9000

加上<<EOF
标记，看看
应该是你脚本执行时，进程断了，所以备份就推出了，没有备份完

zyeline

看了sybase相关技术手册，说Error: 1608是因为一下的原因引起的，但是我的network应该没有问题的。
1.1        Issue:
The following Error appears in the Sybase Error Log
Error 1608, Severity Level, 21
A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.
1.2        Explanation:
This error occurs when a client process stopped without informing SQL Server and a subsequent attempt by SQL Server to send results to this client fails.
Error 1608 is usually not serious and may be viewed as notification that a client process no longer exists. Some of the possible reasons a client process can disappear are:
·        The client application was killed or ended abnormally
·        The client machine was powered off or rebooted
·        There is excessive network traffic
·        The network connection has been dropped or interrupted
1.3        Resolution:
Do not be concerned if this error occurs only sporadically. However, if the error occurs frequently and continuously, or frequently for short periods of time, it may be a result of excessive network traffic or network problems.
If  it is suspected  that there are network problems, contact the network administrator in order to run diagnostics on the network between the client and the SQL Server machines to isolate the problem.
Note:        If this error is preceded by another Sybase error then obtain a complete and current copy of the Sybase error log and forward it to the SPS Help Desk for further analysis. The error log can be found in the c:\sybase\install directory on the server.


刚好今天单位换了新服务器，现在没有这个问题了，以后再说吧。