can't open a connection to site 'syb_backup' 解决
来源:互联网 发布:各数据库特点 编辑:程序博客网 时间:2024/05/16 17:59
今天在恢复一个sybase数据库备份时,在执行load database test from 'd:\test.dat'报错:Can't open a connection to site 'SYB_BACKUP'。检查Sybase BCKServer服务已经启动,在dsedit也可以ping得通Back Server,经过一番折腾,发现master库sysservers表的SYB_BACKUP对应的srvnetname与dsedit中的备份服务名不一致,于是执行update sysservers set srvnetname='XXX_BS' where srvid=1却报Ad-hoc updates to system catalogs not enabled. A user with System Security Officer (SSO) role must reconfigure system to allow this. 错误,这时只需先执行sp_configure "allow update",1再修改sysservers表即可。接着执行load database test from 'd:\test.dat',完成后再执行online database test,大功告成!
总结:
1、出错该错误可以先检查一下Sybase BCKServer服务有没有启动
2、在dsedit看能否ping通备份服务
3、检查master库sysservers表的配置
4、如在备份数据库dump database时报这个错也是一样的方式去检查
5、以上语句可以在SQL Advantage执行,也可在CMD命令下执行:
isql -Usa -Ppassword -Sservername
1>load database test from 'd:\test.dat'
2>go
恢复成功后再执行
1> online database test
2> go
2> go
- can't open a connection to site 'syb_backup' 解决
- 解决can't open a connection to site 'syb_backup'
- Can't open a connection to site 'SYB_BACKUP' 解决办法
- Sybase dump 失败can't open a connection to site 'syb_backup'
- Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE boot directory. Msg
- SYBASE备份报错:Can't open a connection to site 'SYB_BACKUP',see the error log file in the ASE directory
- FileZilla 425 Can't open data connection. 的错误解决
- 425 Can't open data connection
- FileZilla 425 Can't open data connection
- FileZilla 425 Can't open data connection
- FileZilla 425 Can't open data connection
- 425 Can't open data connection 问题解决
- Can’t connect to MySQL server on ‘localhost’(10055) + Can not open connection + Could not execute query
- ftp命令结果提示“500 I won't open a connection to ...”
- jsp Can't start a cloned connection while in manual transaction mode解决
- Can't start a cloned connection while in manual transaction mode 解决
- Sharepoint Designer Can Open Site but Can't Edit Page(Others pc can edit my site page)
- FileZilla FTP 425 Can't open data connection 的问题解决
- Java 之 ThreadLocal学习
- C语言和设计模式(享元模式)
- 周末攒了一台电脑
- Android磁盘管理-之vold源码分析(4)
- java基础笔记2
- can't open a connection to site 'syb_backup' 解决
- Linux下安装php+mysql+apache完整版
- pc-lint
- windows程序崩溃对话框和异常处理
- 软件系统设计思路
- TCP3次握手连接协议和4次握手断开连接协议
- 很牛的牛顿迭代法
- autoReconnect
- 工作思想汇报