出现以上问题主要是因为SYBASE的发布包的一个BUG,即发布包添加的备份服务器和数据库中配置的不正确。
1.检查你的interfaces文件,winodws下是INI文件,文件位置在sybase安装目录/ini/sql.ini
[GUOLEIMAIL_MS]
master=NLWNSCK,guoleimail,5002
query=NLWNSCK,guoleimail,5002
[GUOLEIMAIL_JSAGENT]
master=NLWNSCK,guoleimail,4900
query=NLWNSCK,guoleimail,4900
[ws]
master=NLWNSCK,guoleimail,8186
query=NLWNSCK,guoleimail,8186
[GUOLEIMAIL]
master=NLWNSCK,guoleimail,5000
query=NLWNSCK,guoleimail,5000
[GUOLEIMAIL_XP]
master=NLWNSCK,guoleimail,5003
query=NLWNSCK,guoleimail,5003
[GUOLEIMAIL_BS]
master=NLWNSCK,192.168.0.165,5001
query=NLWNSCK,192.168.0.165,5001
注意最后一个服务器,可以用IP 地址,也可以用机器名这个都有试验过。
2.在INTERACTIVE SQL也就是查询分析器中输入sp_helpserver,