"Phantom" backups listed in Activity History


I'm a SQL Server beginner so this question is asked with a heaping spoonful of ignorance. Having said that, I've written some basic SQL scripts, created Stored Procedures and Views, and have set security permissions so I'm not a complete beginner.

A VAR setup our SQL Server 2017 VM and it's now mine to manage. They originally created to SQL Server Agent jobs that did full backups and log backups. Now that SQL Backup is in place, I disabled those jobs mid-last week.

When I look at the Activity History in SQL Backup I see multiple items that are stating backups (fulls and logs) are being performed outside of the SQL Backup jobs. I can't figure out where these backups are being initiated from nor can I find the files themselves.

  1. When I search my data drive (where the original .bak and .trn files were being stored) there are no new files. Those files all end back on the day I disabled those jobs last week.
  2. The phantom backup activities shown in SQL Backup are happening at times that do not align with the original jobs that are now disabled.
  3. SQL Server Management Studio's Log File View does list some activity that I can correlate to these phantom jobs but the entries are extremely sparse on information. Additionally, these entries indicate that no data was actually backed up.

What else could possibly be initiating these "backups"?

Best Answer

  • petey2petey2 Posts: 69 Silver 3
    Accepted Answer
    Best guess at this point is that it's a snapshot backup performed by your virtual machine, seeing as how they are virtual device backups and they all kick off at the exact same moment.  
    SQL Backup - beyond compression


Sign In or Register to comment.