load后系统提示，不知何意，不吝指教

china_adan

Caution:  You have set up this database to include space on disk 3 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 8 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 9 for both data

and the transaction log.  This can make recovery impossible if that disk fails.
All dumped pages have been loaded.  SQL Server is now clearing pages above page
3840000, which were not present in the database just loaded.
SQL Server has finished clearing database pages.
Redo pass of recovery has processed 60 committed and 5 aborted transactions.

chuxu

在你的设备上data和log混用，可能不好recover。
load应该完成了，online一下试试。
我想应该是你的新设备的尺寸和原设备不一样造成的

china_adan

非常感谢您的回复，我建了d1,d2,L1三个设备，d1、d2为数据，L1为日志。load后我用sp_logdevice 将日志移到L1上，然后填满最后页，用sp_helplog查看发现日志设备为d2。不知何故，望回复，非常感谢。
另外想请教有关sybase12.5行级限制的具体应用，语法。

chuxu

你原来的库是否也是D1,D2,L1三个设备？

china_adan

不是，这和原来设备有关吗？

chuxu

应该是有关系的，如果新的设备尺寸和原设备不一致，就容易出现这种情况