Sample Header Ad - 728x90

Finding what's making VSS/VDI backups

3 votes
2 answers
1264 views
This one's got me a bit perplexed. How might one determine what process/program is making file-level backups via VSS/VDI and the SQL Writer service? I've tried using Profiler to trace backup/restore events, and that just shows me SQL Writer itself creating the backup events. I don't see anything in the Windows event log indicating what's talking to SQL Writer, nor does SQL Server put anything meaningful in its own error log. I've got a situation where *something* is making snapshot backups and breaking the differential chain, but we're not sure what the culprit is. It's undoubtedly some kind of backup agent, or a virtualization assistant that talks to SQL Writer to allow for VM snapshots, but we need some way to pin it down.
Asked by db2 (9708 rep)
Mar 8, 2017, 08:17 PM
Last activity: Mar 15, 2017, 04:01 AM