Chinaunix首页 | 论坛 | 博客
  • 博客访问: 402915
  • 博文数量: 49
  • 博客积分: 2562
  • 博客等级: 少校
  • 技术积分: 417
  • 用 户 组: 普通用户
  • 注册时间: 2005-11-03 09:10
个人简介

时不我待。

文章分类

全部博文(49)

文章存档

2024年(1)

2020年(3)

2013年(1)

2012年(5)

2011年(9)

2010年(4)

2009年(9)

2008年(15)

2005年(2)

分类: Sybase

2008-01-08 21:52:30

在isql中dump database 报出以下错误
"Can't open a connection to site 'SYB_BACKUP'"
检查$SYBASE/install目录,发现没有"RUN_Linux_back"服务,该服务器为sybase备份服务,需要创建sybase备份服务器.
切换sybase用户下,运行srvbuild,选择添加"backup server",确定后,输入sa的密码即可以进行创建.确定后启动backup server,
$SYBASE/install/startserver -f RUN_linux_backup
进入isql dump database 正常.
 
1> dump database master to 'master.dmp'
2> go
WARNING: In order to LOAD the master database, the SQL Server must run in
single-user mode.  If the master database dump uses multiple volumes, you must
execute sp_volchanged on another SQL Server at LOAD time in order to signal
volume changes.
Backup Server session id is:  9.  Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 4.41.1.1: Creating new disk file
/opt/sybase-11.9.2/install/master.dmp.
Backup Server: 6.28.1.1: Dumpfile name 'master0800812E89 ' section number 0001
mounted on disk file '/opt/sybase-11.9.2/install/master.dmp'
Backup Server: 4.58.1.1: Database master: 1068 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database master: 2624 kilobytes DUMPed.
Backup Server: 3.43.1.1: Dump phase number 1 completed.
Backup Server: 3.43.1.1: Dump phase number 2 completed.
Backup Server: 3.43.1.1: Dump phase number 3 completed.
Backup Server: 4.58.1.1: Database master: 2632 kilobytes DUMPed.
Bac
阅读(7558) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~