title: SQL Server: How do I increase the size of the transaction log?
body: <p>How do I increase the size of the transaction log? Is is also possible to temporarily increase the transaction log?</p>
  
  <p>Let's say I have the following scenario. I have a Delete operation that's too big for the current transaction log. I wan't to: </p>
  
  <ul>
  <li>Increase the transaction log (can I detect the current size?, can I tell how large I need the transaction log to be for my operation?)</li>
  <li>(Perform my operation)</li>
  <li>Backup the transaction log</li>
  <li>Restore the size of the transaction log.</li>
  </ul>