[nothing2lose]

This database has a problem which is:

log only free kbytes = 101996 ----- this value is never changed even there are no any transaction on it .


The log devices have a size around 12388 Mb.

Could you advice me about that.

see:

1> sp_helpdb my_db
2> go
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ ------
--------------
------------------------------------------------------------------------------------------------------
my_db 49152.0 MB oasis 4
Mar 06, 2004
select into/bulkcopy/pllsort, allow nulls by default, auto identity, identity in
nonunique index

(1 row affected)
device_fragments size usage
created free kbytes
------------------------------ ------------- --------------------
------------------- ------------------------------
my_db_data1 312.0 MB data and log
Jul 21 2004 11:42AM 318240
my_db_data1 100.0 MB data only
Jul 21 2004 11:42AM 74216
my_db_data1 24064.0 MB data only
Jul 21 2004 11:42AM 24545280
my_db_data1 100.0 MB log only
Jul 21 2004 11:42AM not applicable
my_db_ind1 12288.0 MB data only
Jul 21 2004 11:42AM 12533380
my_db_log1 12288.0 MB log only
Jul 21 2004 11:42AM not applicable

--------------------------------------------------------------
log only free kbytes = 101996
device
segment



------------------------------
---------------------------------------------------------------------------------------------------------------------------

my_db_data1
default



my_db_data1
logsegment



my_db_data1
system



my_db_ind1
index_seg



my_db_log1
logsegment