Is it possible to locate the active transaction, it was not listed in DBCC opentran, the log file keeps getting bigger.
- Database is in Simple recovery
- tried shrinking the database - no luck
Also we have restarted the SQL service, no improvement the log file size keeps increasing.