新建庫load database 數據後異常提示
windows 2000 server服務器 sybase 12.0.0原先服務器故障送修，在另一台服務器上安裝sybase server，參數設定，建立設備後，將原先備份的數據load新數據庫，出現如下提示：
caution: you have set up this database to include space on disk 5 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 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 8 for both data and the transaction log. This can make
recovery impossible if that disk fails.
All dumped pages have bennloaded. SQL server is now clearing pages above page 2816000,which were not present in the database just loaded.
SQL server has finished clearing database pages.
redo pass of recovery has processed 2 committed and 1 aborted transactions.
請教是什麼問題？如何解決？謝謝！ 5 6 8设备是数据和日志混用，今后使用的时候可能影响恢复。
别的没有什么大关系。
执行一下online database 就可以了 看了下5 6 8設備分配一半是data，一半是log，能將log轉換為data麼？ 要看你dump的库是否也存在同样的问题，如果不存在，就是load的库建的和源库不一致，不但总大小要相同，而且每个设备必须一样打，最好如果源库曾经alter过，目标库也用alter的方法建。 問題就在源庫設備的大小，麻煩！謝謝chuxu，我再想其它方法。
页:
[1]