Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2004
    Posts
    7

    Unanswered: log only free kbytes value is never changed

    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
    Last edited by nothing2lose; 10-05-04 at 02:55.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •