|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?站点注册
×
本人对刚装的数据库进行load完数据后报错,一下是显示的信息: Line 1: Caution: You have set up this database to include space on disk 2 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 4 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 5 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 6 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 4608000, which were not present in the database just loaded. SQL Server has finished clearing database pages. Use the ONLINE DATABASE command to bring this database online; SQL Server will not bring it online automatically. Database 'aa' is now online.
请问各位大侠,以上是什么意思?为什么会出现这种提示信息?该怎样解决才能在以后进行load数据库时不再出现以上提示信息?还有就是我发现在load数据前后数据库显示信息不同,如下: 刚建好数据库没有进行load数据的时候 credits 9500.0 MB credits 5 Jun 14, 2006 no options set
device_fragments size usage free kbytes ------------------------------ ------------- -------------------- ----------- credits_dev 1900.0 MB data only 1945600 credits_dev1 1900.0 MB data only 1945600 credits_dev2 1900.0 MB data only 1945600 credits_dev3 1900.0 MB data only 1945600 credits_log_dev 1900.0 MB log only 1945600
(return status = 0)
做load数据库后变成: credits 9500.0 MB credits 5 Jun 14, 2006 no options set
device_fragments size usage free kbytes ------------------------------ ------------- -------------------- ----------- credits_dev 600.0 MB data only 688 credits_dev 940.0 MB data only 192 credits_dev 360.0 MB log only 216608 credits_dev1 1900.0 MB data only 656 credits_dev2 602.0 MB data only 128768 credits_dev2 700.0 MB data only 716800 credits_dev2 598.0 MB log only 612352 credits_dev3 100.0 MB data and log 25712 credits_dev3 100.0 MB data only 102400 credits_dev3 1200.0 MB data only 1228800 credits_dev3 500.0 MB log only 512000 credits_log_dev 1400.0 MB data only 1433600 credits_log_dev 500.0 MB log only 512000
(return status = 0)
该怎样解决才能在以后进行load数据库后,数据库的显示信息相同?
|
|