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

Advertisements

Leave a comment

Filed under Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s