title: "The transaction log for database is full due to 'LOG_BACKUP'" in a shared host
body: <p>I have an Asp.Net MVC 5 website with EntityFramework codefirst approach in a shared hosting plan. It uses the open source <a href="http://www.websitepanel.net/">WebbsitePanel</a> for control panel and its SQL Server panel is somewhat limited. Today when I wanted to edit the database, I encountered this error:</p>
  
  <pre><code>The transaction log for database 'db_name' is full due to 'LOG_BACKUP'
  </code></pre>
  
  <p>I searched around and found a lot of related answers like <a href="https://stackoverflow.com/questions/8025344/transaction-log-for-database-is-full-sql-error">this</a> and <a href="https://stackoverflow.com/questions/13975905/potential-causes-and-solutions-for-the-transaction-log-in-database-being-full">this</a> or <a href="https://stackoverflow.com/questions/56628/how-do-you-clear-the-sql-server-transaction-log">this</a> but the problem is they suggest running a query on the database. I tried running </p>
  
  <pre><code>db.Database.ExecuteSqlCommand("ALTER DATABASE db_name SET RECOVERY SIMPLE;");
  </code></pre>
  
  <p>with the visual studio (on the <code>HomeController</code>) but I get the following error:</p>
  
  <pre><code>System.Data.SqlClient.SqlException: ALTER DATABASE statement not allowed within multi-statement transaction.
  </code></pre>
  
  <p>How can I solve my problem? Should I contact the support team (which is a little poor for my host) or can I solve this myself?</p>