SQLCrazyCertified (3/15/2013)
GilaMonster (3/15/2013)
Exactly what it says, all logical log files are in use, so there are no empty ones. No empty VLFs = no shrink.Check log_reuse_wait_desc in sys.databases for why the log is not being reused.
Ok....got it, finally it allowed me to shrink, I gues a lot of activities were happening behind. Anyway, thanks for all of your input.
Regards,
SueTons.
In the future you can use DBCC LOGINFO to check the status of the t-log VLFs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉