Monthly Archives: January 2016

LDF file not getting shrink even after Tlog backup SQL server

Dear All,

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

Use DBNAME

sp_removedbreplication

That’s all , Error wend away and all started working

Thank You,

Prashant Deshpande

Leave a comment

Filed under Uncategorized