When trying to access ServiceDesk, the following error message occurs:
The transaction log for database 'Ensemble' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
Creating new tickets may also fail to work or result in the above error.
The transaction log of the Ensemble database is full.
Use one of the following three methods to truncate the transaction log, then change the SQL recovery method for the Ensemble DB to Simple.
For more information on truncating the transaction log, please refer to the following article:
How to shrink the Notification Server transaction log
Service Desk 7.0