Skip to main content

SQL database: The transaction log for database ''xxx'' is full

The error message ‘The transaction log for database xxx is full’ is not generated by PROMODAG Reports, but by Microsoft SQL Server.

It is self-explanatory and actually means that the transaction log for the Promodag database has run out of space. Database and transaction log growth are not managed by PROMODAG Reports, but by tools provided with Microsoft SQL Server (SQL Enterprise Manager, SQL Server Management Studio).

Microsoft provide some useful explanations and solutions to avoid this situation in their Knowledge Base:
 

We recommend to apply the 'Simple' recovery model to the database. In this case, log truncation occurs automatically after a checkpoint. So this recovery model automatically reclaims log space to keep space requirements small, essentially eliminating the need to manage the transaction log space.

 

About the author

Promodag

Our flagship reporting tool, Promodag Reports, is an innovative and constantly improving email reporting product that brings together all the key elements from Office 365, hybrid and on-premise Exchange messaging environments.

Try Promodag Reports Free for 45 Days

Cookie Notice

Find out more about how this website uses cookies to enhance your browsing experience.