load数据出现问题，求助，在线等.......

xmm1981

免费乐捐，感谢支持

load database fydb from 'h:\fydbback\back1.dmp'
stripe on 'h:\fydbback\back2.dmp'
stripe on 'h:\fydbback\back3.dmp'
stripe on 'h:\fydbback\back4.dmp'
stripe on 'h:\fydbback\back5.dmp'
stripe on 'h:\fydbback\back6.dmp'
stripe on 'h:\fydbback\back7.dmp'
stripe on 'h:\fydbback\back8.dmp'
stripe on 'h:\fydbback\back9.dmp'
stripe on 'h:\fydbback\back10.dmp'
go

.
.
Backup Server: 4.58.1.1: Database fydb: 18781142 kilobytes LOADed.
Backup Server: 3.42.1.1: LOAD is complete (database fydb).

Caution: You have set up this database to include space on disk 6 for both data
and the transaction log. This can make recovery impossible if that disk fails.
Caution: You have set up this database to include space on disk 19 for both
data and the transaction log. This can make recovery impossible if that disk
fails.

此二句翻译如下:
小心: 你设定这个数据库包括空间在盘6 为数据和交易日 志。这可能使补救不可能如果那张盘失败。
小心: 你设定这个数据 库包括空间在盘19 为数据和交易日志。这可能使补救不可能如果那 张盘失败。

导入数据以后,出现此问题，不能online数据库....

请问这个问题怎么解决？

ehxz

搞不清楚，你用的是10个备份出来的文件，提示为什么却是6跟19？

这种备份方式没用过。不过估计你的库很大了吧。

xmm1981

是啊，呜........

ehxz

你原来是如何备份的,如果不是你自己备的,是不是文件有问题啊?

flybean

日志和数据应分布在不同的设备上，但你的数据和日志在同一设备上。可调整，即将日志移到其它设备上。

有两种方法：
方法一：使用SYBASE　Central，建议初学者使用
方法二：

1. Backup the database.
2. Sp_dropsegment log_segname, dbname, [device]
3. Sp_logdevice dbname, devname

[此贴子已经被作者于2005-11-13 0:34:06编辑过]

xmm1981

能否具体点，谢谢....load后出错提示，和online之后的出错提示

.

Backup Server: 4.58.1.1: Database fydb: 18781142 kilobytes LOADed.

Backup Server: 3.42.1.1: LOAD is complete (database fydb).

Caution: You have set up this database to include space on disk 6 for both data

and the transaction log. This can make recovery impossible if that disk fails.

Caution: You have set up this database to include space on disk 19 for both

data and the transaction log. This can make recovery impossible if that disk fails.

1> online database fydb

2> go

Msg 930, Level 14, State 1:

Line 1:

Database 'fydb' cannot be opened because either an earlier system termination

left LOAD DATABASE incomplete or the database is created with 'for load' option.

Load the database or contact a user with System Administrator (SA) role.

1>

flybean

ONLINE没成功的原因是：load database没有完成

xmm1981

免费乐捐，感谢支持

Backup Server: 4.58.1.1: Database fydb: 18781142 kilobytes LOADed.>>

Backup Server: 3.42.1.1: LOAD is complete (database fydb).

你没有看吗？已经complete了