Perfect
--- 1. Query
SELECT name, log_reuse_wait_desc FROM sys.databases
--- check if MyDatabaseName says
--- log_reuse_wait_desc = Replication
--- 2. Force removal of the replication.
EXEC sp_removedbreplication MyDatabaseName
--- 3. Check
SELECT name, log_reuse_wait_desc FROM sys.databases
--- check if MyDatabaseName says
--- log_reuse_wait_desc = Nothing
--- 4. Force your DB to Simple Recovery:
ALTER DATABASE MyDatabaseName SET RECOVERY SIMPLE
--- 5. Run db shrink command
backup log MyDatabaseName with truncate_only
dbcc shrinkfile(MyDatabaseNameLog)
--- Perfect
--- thanks again 🙂