[求助]load出错
用load倒数据是出错:Msg 5018, Level 17, State 1:<BR>Line 1:<BR>Caution:You have set up this database to include space on disk 4 for both data<BR>and the transaction log.This can make recovery impossible if that disk fails.<BR>Msg 5018, Level 17, State 1:<BR>Line 1:<BR>Caution:You have set up this database to include space on disk 7 for both data<BR>and the transaction log.This can make recovery impossible if that disk fails.<BR>All dumped pages have been loaded.SQL Server is now clearing pages above page<BR>713216, which were not present in the database just loaded.<BR>SQL Server has finished clearing database pages.<BR>122 transactions rolled forward.<BR>Use the ONLINE DATABASE command to bring this database online; SQL Server will<BR>not bring it online automatically.是什么意思,该怎么样解决呢?<BR> 好象空间不够?检查一下看看。[求助]load出错
空间是够的。因为我导出数据的设备空间比要导入数据的设备要小 load是成功的,需要online database<br>另外,你的数据和日志共用了一个设备。<br>
<P>楼上是正解。</P> <P>You have set up this database to include space on disk 4 for both data<BR>and the transaction log</P>
<P>disk 4 被设置成了数据和日志共用的设备</P>
页:
[1]