troubleshooting Question

How do I find out what is creating these backups to Azure?

Avatar of dbaSQL
dbaSQLFlag for United States of America asked on
Microsoft SQL ServerAzure
7 Comments1 Solution96 ViewsLast Modified:
I just deployed a change yesterday to a couple of servers so the backups are now being written to Azure Blob Storage.  Everything tested well, and looked good -- until today.  I am seeing FULL backups running hourly -- that I am not running.  I am also seeing  transaction log backups coming in more frequently -- that I am also not running.  I have queried the backup history and can see that the FULLs are all copy_only backups -- but again, I have no idea what is running  them.

This is the URL that I am targeting with the backup command to write the files, and I have confirmed the ones I expected were written to this location:
 @URL = 'https://companynameprodbackups.blob.core.windows.net/sqlbackups/'

This is where all of the other backups are being written:
https://companynamebackupstore.blob.core.windows.net/39e6490f14b24fcfa34606d184baa7f1/dbname_1c97a7a0d3184c5d9355a7ee99f7ff1a_b2a72d1bcf5d4cd99540ce881f63554f_20180822111208-06.log
https://companynamebackupstore.blob.core.windows.net/39e6490f14b24fcfa34606d184baa7f1/dbname_595d1e54a57548b7977f5c218c6f3df1_8cd2a3504f2a464cab281ccddc9b3817_20180822111209-06.bak



How do I find out what is creating these backups?
ASKER CERTIFIED SOLUTION
lcohan
Database Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros