One transaction log file is growing and growing for a couple of days and I can't find out why. Now I figured out that either the way the activities are stored in the sql logfile OR the behaviour of sql server/backup software changed.
The log files have been backed up every 15 minutes by a third party software.
Until a specific point some days ago, the log backup event is visible every 15 mins as it always used to in the log with the following entries (newer first):
BackupLog: SafeCheckpoint done
Backup: Media open
BackupLog: Work estimate done
BackupLog: Log files done
BackupLog: Writing history records
Log was backed up. Database: xy_db, creation date(time): 2014/01/10(03:31:14), first LSN: .............. This is an informational message only. No user action is required.
BackupLog: Writing history records
BackupLog: Finished
After that specific day, there is no more such entry visible. But instead I can see the following log entries indicating something like a log backup as well (newer first):
BackupDatabase: Log files done
Database differential changes were backed up....
Completed file yyy.mdf
Started file xxx.mdf
BackupDatabase: Log files done
BackupDatabase: Database xy_db
I wonder if or why the presentation of the log backups may have changed and if the new (bolded) entries indicate the same action? I have checked
DBCC TRACESTATUS (3226);
that tells me status = 0
but I can't find any hints in the log that this ever has been changed these days what also makes me unsure if those Backup Log" entries I was used to ever depended on this trace flag?
EDIT: I have checked the trace flags for different servers. the trace flag 3226 is turned off but I can see the Log entries I am used to in the sql server logs. So this seems not to be involved here.
Where are those different / new log entries possibly coming from?