SQL SERVER – Unable to Attach Database – File Activation Failure – The Log Cannot be Rebuilt

A client lost the log drive and tried ATTACH_REBUILD_LOG, only to get a file activation failure: the log cannot be rebuilt. Here is why and what they could do.