🚀 go-pugleaf

You don't mention which version of SQL you are using.  Try:

use <database>
go
dbcc checktable (syslogs)
go


Glenn R. Kurban wrote in message ...
>This is probably a fairly common problem since it has happened to me
>before resulting in my having to restore a whole database (testing
>database, luckily); however, I have never received a solution for it.
>
>The transaction log in one of my development databases ran out of log
>space completely (zero, zilch, nada...)  Upon truncating the log with
>'no_log,' I was left with only 20MB of a 148MB log for me to work with.
>Nothing I try will free-up the rest of my transaction log. DBCC opentran
>shows NO open transactions...I dont know what to do.  Please, any help
>would be greatly appreciated.
>
>Thanks,
>Glenn K.




Opinions expressed herein are my own and may not represent those of my employer.