The transaction Log file is saved on the disk drive. You must free the disk space that contains the Log file.
To create space in the drive, delete or move other files.
The free space on the disk allows it to perform other tasks and resolves
SQL Error Log 9002 The Transaction Log for Database is Full.
For more information about
LOG_BACKUP, see
https://docs.microsoft.com/en-us/sql/relational-databases/logs/the-transaction-log-sql-server?view=sql-server-ver15
To check the partition of the LDF file for ePO_Events DB stored:
- Make a backup of the ePO database. See KB52126 for details.
- Log on to SQl Management Studio.
- Expand Databases in Object Explorer.
- Right-click on the database name for your ePO server and select New Query. For details, see KB67591.
- Paste the script provided into the query window.
- Click Execute or press the F5 key.
SP_helpdb ePO_XXXXXXXXX_Events
Example: SP_helpdb ePO_RGCMCAFEEEPO_Events
NOTE: This script helps to check the partition and size of each MDF, NDF, and LDF file.