title: How to Shrink Transaction log in sql server database in replication
body: <p>Hi I'm having a production database and its replicated report database. How to shrink the transaction log files in the production database as the log file size is increasing. I had tried  <strong>DBCC SHRINKFILE</strong> and <strong>SHRINKDATABASE</strong> commands but it does not work for me. I can't detach and shrink and attach back as the db in replication. Please help me in this issue.</p>