transaction log
2 Topics- Lesson Learned #421:Understanding and Troubleshooting Transaction Log Truncation in Azure SQL DBAzure SQL Database, Microsoft's cloud-based database service, manages many administrative functions automatically, such as backups and patching. However, understanding the behavior of the transaction log, especially its truncation, remains crucial. This article delves into potential reasons why a transaction log might not truncate as expected and offers steps to investigate and address these concerns.2.1KViews0likes0Comments
- Lesson Learned #7: Monitoring the transaction log space of my databaseFirst published on MSDN on Oct 31, 2016 In many support cases, our customers want to monitor the available space for the transaction log space for their database or to know what caused an error when the transaction is full.3.8KViews1like0Comments