The transaction log getting full when saving/deleting collections

Posts   
 
    
nalwi
User
Posts: 10
Joined: 01-Oct-2008
# Posted on: 22-Oct-2009 08:00:51   

version: LLBL Gen version 2.6

We get the following error randomly on some instances when calling DeleteEntitiesDirectly or SaveEntityCollection methods.

SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException: An exception was caught during the execution of an action query: The transaction log for database {dbname} is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

Any Ideas on this? Is there a way to switch off transaction when calling DeleteEntitiesDirectly or SaveEntityCollection ?

Thanks!

DvK
User
Posts: 318
Joined: 22-Mar-2006
# Posted on: 22-Oct-2009 10:02:30   

Impossibe to disable Logging on the TransactionLog. Set the Recovery model to Simple and your problem is gone but this is not something you want to implement on Production databases, or enlarge the max size of the TransactionLog.....or regularly backup your TransactionLog.

Regards, Danny