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
相关文章
- filezilla Can't open data connection.
- "ifcfg-eth0" E212: Can't open file for writing Press ENTER or type command to continue
- 关于vi下面 E212: Can't open file for writing的问题
- Mysql报错Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- vi E212:Can't open file for writing 报错
- Linux :: vi E212: Can't open file for writing
- vim出现“E212: Can't open file for writing”的处理办法
- Linux中修改文件报 E212: Can't open file for writing
- linux下错误代码E212: Can't open file for writing
- Linux vim修改文件时遇到:E212 can't open file for writing