Since a couple of days, I started receiving alerts from my sql server as follows
DATE/TIME: 16/02/2022 09:07:25
DESCRIPTION: The transaction log for database ‘SQLWATCH’ is full due to ‘ACTIVE_TRANSACTION’.
COMMENT: statement caused SQL Server to run out of resources (such as memory, locks, or disk space for the database) or to exceed some limit set by the system administrator.
I have no issues with resources on the sql box, after googling, I backed up the sqlwatch DB, restarted the server but always getting this alert.
Can you please help?