sp_configure "allow update",1
- go
- update sysservers set srvname='SYB_BACKUP', srvnetname='服务器名_BS' where srvid=1
- go
sp_configure "allow update",0
- go
Select * from sysservers(查看名字)
YUNZD420_BS 计算机名
再去恢复就可以进行了
1、出错检查Sybase BCKServer服务有没有启动2、在dsedit看能否ping通备份服务3、检查master库sysservers表的配置4、如在备份数据库dump database时报这个错也是一样的方式去检查5、以上语句可以在SQL Advantage执行,也可在CMD命令下执行:isql -Usa -Ppassword -Sservername1>load database test from 'd:\test.dat'2>go恢复成功后再执行1> online database test 2> go
相关文章
- Fatal error: Can‘t open and lock privilege tables: Table ‘‘ doesn‘t exist的解决方法
- keil编译报错,(3): warning C318: can‘t open file...
- mysql5.5 报Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- 解决unixODBC的Driver Manager报错:Can‘t open lib ‘xxx/‘ : file not found
- SVN报错:can't open file db/txn-current-lock:permission denied 解决方法
- Can‘t open PID file /var/run/keepalived.pid (yet?) after start: No such file or directory
- Ubuntu16.04 vi编辑器保存文件出现Can‘t open file or writing报错的解决方法
- 自己制作rootfs无法启动,提示can‘t open ‘dev/null‘:no such file or directory
- 如何解决远程连接mysql出现Can’t connect to MySQL server on (111 “Connection refused”)的问题
- filezilla Can't open data connection.