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