We have few servers where backups are running from an unknown source. The physical_device_name in the backupmediafamily table is something like
I was checking randomly and noticed this kind of backup was running on the database. So I stopped SQL Server VSS Writer service and the backup process stopped. It prompted me to think that backups are being also being conducted by this service. I am still unaware on how Windows/SQL decides to trigger these backup at particular times only since the SQL Server VSS Writer service is running 24*7.
I have also seen cases on few servers where SQL Server VSS Writer is running but those backups are not happening at database level.
Can someone please help me in understanding (identifying) what is causing SQL Server to trigger such backups as I want to stop them across entire organisation.