Hey all! My backup solution (Barracuda Backup 490 appliance) has been failing on differential backups of some of our SQL databases (the same 9 databases out of 25 in that particular instance, we have several other SQL instances that are backing up fine on the same backup job). The jist of the error message as I understand it is that an operation has caused a log truncate, breaking the log chain, and thus breaking the diff backup of the database.
So I always forget just how little I understand SQL until I'm forced to go troubleshoot a problem like this. I figured this would be easy, but so far I'm coming up empty....what I'm looking for is a simple and concise way to pull a record of all instances where a database was truncated (breaking the log chain) so I can try and figure out what exactly is causing this and evaluate how to move forward.
From my googling, and the responses I'm reading, I'm sure lots of people will have lots of very good suggestions about how to approach this problem and things to check, and I appreciate it all. But what's most important to me right now, and what I would be really thankful for if anyone can oblige, would be a query, or an Event Viewer filter or something that will give me a time-stamped list of every time a database's log was truncated? Thanks in advanced!