Try truncating the log first. Use
BACKUP LOG mydb WITH TRUNCATE_ONLY
You WILL have to perform a full database backup afterwards. You might want to verify that you don't have any open transactions that are keeping the log from being shrunk and truncated. Use DBCC OPENTRAN().
-Mike
>When I execute a dbcc shrinkfile(MyDatabase,) I get the error message
>"Cannot shrink log file 2 (MyDatabase) because all logical log files are in use."
>I have tried things like taking the database off and on line and stopping and restarting the database to try to get rid of this error.
>
>Anyon know how to deal with this ?
>
>Thanks,