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

Method 1: 

Src: https://www.mssqltips.com/sqlservertip/3579/how-to-attach-a-sql-server-database-without-a-transaction-log-and-with-open-transactions/

Last Resort:

CREATE DATABASE SQLAuthority

ON (FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\file.mdf')

FOR ATTACH_FORCE_REBUILD_LOG

Src:
https://blog.sqlauthority.com/2016/11/04/sql-server-unable-attach-database-file-activation-failure-log-cannot-rebuilt/