July 9, 2019 at 2:32 pm
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.
July 9, 2019 at 2:42 pm
besides the real-time monitoring using dmv, there are two valuable sources of information:
1) msdb.dbo.backuphistory
2) default trace and "backup/restore" event
https://www.mssqltips.com/sqlservertip/3445/using-the-sql-server-default-trace-to-audit-events/
July 9, 2019 at 2:51 pm
S 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.
Program name looks like Veritas BackupExec
Using OS command line utility "tasklist" you can schedule local job to get list of active processes on the remote server which backs up your dbs.
example:
tasklist /S servername /FI "STATUS eq RUNNING" /V
July 9, 2019 at 3:41 pm
Talk to your network sysadmins. Likely BackupExec is running for general file backups as well. There isn't anything wrong with the agent here, but practice restores to a new machine and make sure you (or they) can restore a system. I'd set up a test db and add data to a table, marking it with a lot, before and after log/diff backups. Ensure you can restore to any point in time.
July 11, 2019 at 12:58 pm
thanks all.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply