Lynn Pettis (3/15/2013)
If the (or an) active VLF is at the end of the log file, the file will not shrink. All I can suggest is keep trying after each log backup.
Cannot shrink log file 2 (DatabaseName_Log) because all logical log files are in use.
(1 row(s) affected)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
What exactly this means?
SueTons.
Regards,
SQLisAwe5oMe.