Today I seen for one of databases while trying to shrink Log file ( LDF ) for SQL Server even after taking Transaction log (tlog) backup, after lots of struggle I got solution by using below query.
select log_reuse_wait_desc from sys.databases where name ‘DBNAME’
the output of above query was ‘REPLICATION’
, actually in my case long back I have removed replication but still some objects where having replication entries so the shrink was not working so executed below command
That’s all , Error wend away and all started working