Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    7

    Unanswered: Where is the transaction log information kept?

    I'm assuming that in one of the MSDB tables I can find transaction log information (current size, amount of space used.. blah blah).. but I can't seem to figure out which one.. any help is appreciated.. SQL 7.0

    Travis

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    look at sysfiles each db has its own sysfiles table.

    Regards,

    hmscott

  3. #3
    Join Date
    Feb 2004
    Posts
    7
    Ok.. I see that.. I'm assuming you have to multiply the size by 8 to get the real size.. but that is telling me the allocated space.. can I tell how much of the allocated space is being used.. I'm trying to monitor my transaction log size to see if it is shrinking when it is supposed to ..

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Look in Books Online for DBCC SQLPERF (LOGSPACE). The output is fairly intuitive, though. This works for SQL 2000 and SQL 7.0.

  5. #5
    Join Date
    Feb 2004
    Posts
    7
    thanks..

    That is exactly what I was looking for..

    Travis

Posting Permissions

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