Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    15

    Unanswered: log only free kbytes

    What does "log only free kbytes" mean? Is this the space available in transaction log?

    sp_helpdb tempdb
    go
    name db_size owner dbid created status

    ------------------------ ------------- ------------------------ ------ -------------- ---------------------------------------------
    ---------------------------------------------------------
    tempdb 3074.0 MB sa 2 Nov 28, 2002 select into/bulkcopy/pllsort


    (1 row affected)
    device_fragments size usage free kbytes
    ------------------------------ ------------- -------------------- ----------------
    D_tempdb_1 2048.0 MB data only 2055866
    L_tempdb_1 1024.0 MB log only not applicable
    master 2.0 MB data only 814

    --------------------------------------------------------------
    log only free kbytes = 307964

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    Yes, it's the free space in the transaction log.

    Michael

Posting Permissions

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