Hi, my log has grown out of proportion after performing an indexdefrag in bulk-logged mode!
Now I cant shrink the damn thing coz I have forgotton how to shrink it when the logical log files are still in use.


Can somebody enlighten me please. thankyou.

error msg: "
Cannot shrink log file 2 (MyDatabase_Log) because all logical log files are in use."