title: SQL SERVER Transaction log full
body: <p>How to free Transaction log space in SQL SERVER 2005:</p>
  
  <p>I have Transaction log size = 70 GB and there four transaction logs 1,2,3,4 in different drives.
  Through DBCC SQLPERF(LOGSPACE) I found that the transaction log is Full (uses 100 %) and I want to free up the space in transaction log and I don't want T-log backup. I don't have space to backup the transaction log.  And my DB is in Replication state.</p>
  
  <ol>
  <li>How can I free up the Transaction log or </li>
  <li>Instead of 3 transaction log files, can I have only one log file or</li>
  <li>If shrink method what to do with Replication?</li>
  </ol>