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
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 ..