What causes the error "Table "Sessionlog". The transaction log for database "DBName" is full" - and how can this be recovered or avoided?
What causes the error - "Table "Sessionlog". The transaction log for database "DBName" is full" - and how can this be recovered or avoided?
The log that is full, is the database transaction log, which is generated by MS SQL Server.
The log is generated and the space it uses, are controlled by the MS SQL Server Option "Recovery Model"
Enterprise Analyzer will work with either "Simple", "Full" or "Bulk Logged" recovery model.
The attached document describes the models available and how they work.
The problem is that the recovery model "Full" or "Bulk Logged" is being used, and no database backups are being performed. This means that the log will continue to grow until either, a) the database runs out of physical space or cannot be extened, or b) a database backup is performed.
A database backup will, backup the database, clear down the log and release the space it has used, ready for re-use.
Micro Focus recommend that a backup/recovery plan/process is set up to secure the repository, as this is not supplied with the Enterprise Analyzer product, and would be the responsibility of the Database Administrator.