07-20-2023, 06:15 AM
I have an Asp.Net MVC 5 website with EntityFramework codefirst approach in a shared hosting plan. It uses the open source [WebbsitePanel](
The transaction log for database 'db_name' is full due to 'LOG_BACKUP'
I searched around and found a lot of related answers like [this](
db.Database.ExecuteSqlCommand("ALTER DATABASE db_name SET RECOVERY SIMPLE;");
with the visual studio (on the `HomeController`) but I get the following error:
System.Data.SqlClient.SqlException: ALTER DATABASE statement not allowed within multi-statement transaction.
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?
[To see links please register here]
) for control panel and its SQL Server panel is somewhat limited. Today when I wanted to edit the database, I encountered this error:The transaction log for database 'db_name' is full due to 'LOG_BACKUP'
I searched around and found a lot of related answers like [this](
[To see links please register here]
) and [this]([To see links please register here]
) or [this]([To see links please register here]
) but the problem is they suggest running a query on the database. I tried runningdb.Database.ExecuteSqlCommand("ALTER DATABASE db_name SET RECOVERY SIMPLE;");
with the visual studio (on the `HomeController`) but I get the following error:
System.Data.SqlClient.SqlException: ALTER DATABASE statement not allowed within multi-statement transaction.
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?