1> sp_helpdb
2> go
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ ------
--------------
-----------------------------------------------------------------------
-------------------------------
DingDang2006 176.0 MB sa 6
May 27, 2006
no options set
master 50.0 MB sa 1
Apr 28, 2006
mixed log and data
model 2.0 MB sa 3
Apr 28, 2006
mixed log and data
sinohydro 500.0 MB sa 4
May 09, 2006
select into/bulkcopy/pllsort, mixed log and data
sinohydroOA 1760.0 MB sa 5
Aug 27, 2006
no options set
sybsystemdb 2.0 MB sa 31513
Apr 28, 2006
mixed log and data
sybsystemprocs 120.0 MB sa 31514
Apr 28, 2006
trunc log on chkpt, mixed log and data
tempdb 503.0 MB sa 2
Sep 29, 2006
select into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data
(1 row affected)
(return status = 0)
1> dump database DingDang2006 to "/sybase/datasinohydro"
2> go
Msg 7205, Level 17, State 2:
Server 'sinohydro', Line 1:
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL
Server boot directory.
Msg 7205, Level 18, State 3:
Server 'sinohydro', Line 1:
Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL
Server boot directory.
我要备份DingDang2006 怎么备不了啊
(环境:用win NT 备份远程UNIX下的SYbase数据库,sybase数据库用户名sa,密码123#abc,数据库名字sinohydro)作者: szbjshhnsd 时间: 2006-10-10 13:43
检查备份服务是否配置正确
如配置正确,检查是否运行作者: zhuyong486 时间: 2006-10-10 14:56
谢谢 现在启动了
现在出现
1> dump database DingDang2006 to "/datasinohydro"
2> go
Backup Server session id is: 11. 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 /datasinohydro.
Backup Server: 4.141.2.40: [7] The 'open' call failed for device
'/datasinohydro' with error number 13 (Permission denied). Refer to your
operating system documentation for further details.
Msg 8009, Level 16, State 1:
Server 'sinohydro', Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages for
details.