Something is running full backups of databases on a SQL server I've inherited and I'm struggling to locate what.
I've put on a server side trace which is telling me which server it's coming from > the SQL host. I see a generic user being used which doesn't tie it down much for me. I see in the backup metadata tables a physical device name of device_type 7 which I can't locate (presumably because it's virtual). I have a client pid which I can try and use somehow but not sure how to do this unless I'm on the server at the time the backups are being run (night). Maybe I can powershell out pids <> programs over the course of the night somehow. Nothing relevant in task manager & it's not a SQL agent job or maintenance plan. Program = Backup Exec SQL Server Agent.
Ideas / pointers gratefully received.