0

I have some automated backups that i want to disable. but i do not know how to do it. Apparently these are done via Volume Shadow copy Service .

Can anyone tell how to get rid of these backups ?

enter image description here

closed as unclear what you're asking by Shawn Melton, Andriy M, Tom V, Colin 't Hart, Max Vernon Nov 17 '15 at 14:27

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • You likely have some third party software taking backups. Why do you want to delete this? – Max Vernon Nov 9 '15 at 15:09
  • I want to have backup plan using the GUI of SQL SERVER and have full control of all backups. – Java Main Nov 9 '15 at 15:13
  • Is it SQL SERVER WRITER the service responsible for this Shadow backups ? – Java Main Nov 9 '15 at 15:30
  • No they are not responsible for backup but these services allow third party backup tools as a medium to connect to SQL Server and perform backup. So yes if you disable SQL Server VSS writer service these backups will fail. – Shanky Nov 9 '15 at 15:38
  • Another disatvantage of these backups is that i get each time I/O Forozen which is very bad if someone queries the DB . – Java Main Nov 9 '15 at 15:43
1

You will need to do a trace or Extended Event session to determine what application is attempting the backups. Be sure to include the client hostname and application name, those two generally help indicate what is taking the backup. The client hostname will most always show the local machine name, which if that is the case look at what is installed on the server.

Some examples of 3rd products that will use VSS:

  • Symantec NetBackup SQL Agent
  • Symantec Backup Exec ( I believe does this now as well)
  • VMWare/Hyper-V (both products have options to along with snapshot of server to also do database)
  • I will try to find what is doing shadow backups . But can i just kill SQLWRITER service and all is ok ? – Java Main Nov 10 '15 at 8:35
  • I found that i have scheduled some backups of the C:\ drive folders . – Java Main Nov 10 '15 at 9:46

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