load 时报错如下：

cybergang

Backup Server: 3.42.1.1: LOAD is complete (database xxxx).
Msg 5018, Level 17, State 1:
Line 1:
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.
Msg 5018, Level 17, State 1:
Line 1:
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 been loaded.  SQL Server is now clearing pages above page
2662400, which were not present in the database just loaded.
SQL Server has finished clearing database pages.
711 transactions rolled forward.
Use the ONLINE DATABASE command to bring this database online; SQL Server will
not bring it online automatically.
User pubuesr in database credits has suid 4, which is the same as the suid of
the DBO (as defined in Sysdatabases).  User pubuesr will be given suid -99.
When all load transactions have been completed for database credits, user
pubuesr should be given a unique suid.
1>; 2>; 3>;
我把日志和数据建在了同一设备上，会不会影响数据库了的数据丢失呢？？？？？？？？？？？？？？？？？？   

jasonshan

load进来的数据库设备的次序、大小、用途必须和原来做dump时的数据库完全一致，如果你原来是data and log，那么现在也是data and log
另外，load完成后要用online database命令激活数据库，否则不能使用

cybergang

我现在不能改了，会不会造成影响？？

jasonshan

如果设备次序、大小或用途不对，肯定有影响

chuxu

不影响一般的使用，但没法通过log恢复了