• Hopefully, this will clear it up because it is confusing me. I ran DBCC Shrinkfile and it would return that it could not find the log file. So I ran the 'select name from sysfiles' command and it returned the file names for the live database and not the test database which I was working with. I believe that is the logical name is what it returns. So am I overreacting to this? How do I shrink the log file then?

    Thanks for the help.

    Frank