Stuart Davies (9/21/2009)
Update:-After a log backup and log shrink things are a bit neater now with regard to dbcc loginfo figures :-
[font="Courier New"]FileId FileSize StartOffset FSeqNo Status Parity CreateLSN
----------- -------------------- -------------------- ----------- ----------- ------ ---------------------------------------
2 253952 8192 38943 2 64 0
2 262144 262144 38938 0 128 0[/font]
yep you have removed all the entries that have already been flushed to disk, so the only remaining virtual files are the ones that have active transactions.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]