3

We have few servers where backups are running from an unknown source. The physical_device_name in the backupmediafamily table is something like {922DDBA9-0686-46B8-94BC-XXXXXXXXXX}2.

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.

  • Are there other Backup solutions in place? I know Amazon Rubrik backup uses VSS/snapshot – Jerry Hung Mar 26 at 9:09
  • 1
    Ask your infrastructure / virtualization / backup admin. It's likely there's a process that backups servers (maybe a Windows OS backup) or a virtual machine snapshot. – vonPryz Mar 26 at 10:54
  • Like mentioned, you probably need to ask other teams for who does this. I don't think you will find in SQL Server who initiated this. In case you want dig deep down, check out: docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/… . – Tibor Karaszi Mar 26 at 12:12
  • Thank you all for the response. I will check with System team to check exactly what is running. In the meantime we have got an approval to stop VSS Writer service on the servers. I think before doing that we should check with System team as well. what do you say? – sachin-SQLServernewbiee Mar 30 at 3:41
1

You will need to identify the Backup strategy which would be using the VSS Writers for taking backups/Restore.

In our environment we had Netbackup and HPDP (Data Protector). While for Netbackup the location would be the master media location ,for HPDP it used to be similar to what you have {922DDBA9-0686-46B8-94BC-XXXXXXXXXX}.

HPDP uses VSS Writers for the backups and it is what was in our case. It can differ in your situation but there is some backup agent which is takin it.

enter image description here

  • Thanks for the response Ramakant. I will check with System team to check exactly what is running. In the meantime we have got an approval to stop VSS Writer service on the servers. I think before doing that we should check with System team as well. what do you say? – sachin-SQLServernewbiee Mar 30 at 3:40
  • Definitely! Backups are a must and till you identify it, make sure you keep the regular backups running. cheers!! – Ramakant Dadhichi Apr 1 at 7:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.