Service Bus transaction log grows ginormous

Problem

Your disk containing SQL Server's data files for Service Bus suddenly becomes full because Service Bus logs a tremendous amount of data. ZervicePoint won't process orders and they stay in "Running" state without any noticeable work being done.

Solution

  • Identify that it really is the Service Bus log that is growing. Default file name is SBMessageContainer01_log.ldf
  • Compact the database. Since this can't be done when the disk is full, you need to follow the steps below

  • Back up your database to a file on another disk, if possible

  • Switch your database (SBMessageContainer01_log.ldf to use Simple recovery
  • Shrink the database

  • Restart Workflow Manager and Service Bus

Stop-WFHost
Stop-SBFarm
Start-SBFarm
Start-WFHost
  • Wait for orders to start to process again. This could take long time. So long that you might think it has stopped again.

More in this thread

social.msdn.microsoft.com