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...