- 论坛徽章:
- 0
|
各位大虾,帮我看看我的数据库是怎么回事?怎么去修正该错误?
1>;sp_helpdb mydb
2>;go
name db_size owner dbid created status
---- ------- ----- ----------- ------- ------
mydb 12000.0 MB sa 4 Mar 06, 2003 select into/bulkcopy/pllsort, trunc log on chkpt
device_fragments size usage created free kbytes
---------------- ---- ----- ------- -----------
posqtdbs_dev01 450.0 MB data only Mar 6 2003 12:06PM -456
posqtdbs_dev01 1300.0 MB data only Mar 6 2003 12:06PM 91184
posqtdbs_dev01 250.0 MB log only Mar 6 2003 12:06PM not applicable
posqtdbs_dev02 250.0 MB data only Mar 6 2003 12:06PM 225224
posqtdbs_dev02 1560.0 MB data only Mar 6 2003 12:06PM 1520528
posqtdbs_dev02 40.0 MB log only Mar 6 2003 12:06PM not applicable
posqtdbs_dev02 150.0 MB log only Mar 6 2003 12:06PM not applicable
posqtdbs_dev03 1440.0 MB data only Mar 6 2003 12:06PM 1446816
posqtdbs_dev03 560.0 MB log only Mar 6 2003 12:06PM not applicable
posqtdbs_dev04 2000.0 MB data only Mar 6 2003 12:06PM 1933680
posqtdbs_dev05 2000.0 MB data only Mar 6 2003 12:06PM 2040000
posqtlog_dev01 2000.0 MB log only Mar 6 2003 12:06PM not applicable |
|