- 论坛徽章:
- 0
|
我建了一个数据库中
情况如下
sp_helpdb testdb
2> go
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ ------
--------------
------------------------------------------------------------------------------------------------------
testdb 24000.0 MB sa 5
Mar 17, 2004
select into/bulkcopy/pllsort
(1 row affected)
name attribute_class
attribute int_value
char_value
comments
------------------------------ ------------------------------
------------------------------ -----------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
testdb buffer manager
cache binding 1
default data cache
NULL
device_fragments size usage
created free kbytes
------------------------------ ------------- --------------------
------------------- ------------------------------
tes01 20000.0 MB data only
Mar 17 2004 10:45AM 3047438
tesexdat 2000.0 MB data only
Sep 23 2004 11:43AM 2040000
teslog01 2000.0 MB log only
Mar 17 2004 10:45AM not applicable
--------------------------------------------------------------
log only free kbytes = 4074880
一看就不对,使用sp_helpdb查看的信息不对,还有什么方法可以查到具体情况啊, |
|