We have a server running 'Microsoft SQL Server 2008 R2, SP3 (v10.50.6220.0)'.
We noticed a few days ago that the drive space was filling up more than usual for our database backups.
We have a maintenance plan that does a cleanup of old backups and then backs-up our databases. This subplan starts at 8pm Monday-Friday. This plan has been working fine and without issue for the last 10 months.
When we look at the database backup files on the drive we can see that the database was backed up twice. Once at 8pm and again at 12am.
The second run of backups are not duplicates, as they have a different sequence number and the size is also different. Example below:
DB1_backup_2018_03_15_220013_1630288.bak – Time Stamp: 3/15/2018 8:05PM – Size: 21,726,335 KB
DB1_backup_2018_03_15_220013_6675138.bak – Time Stamp: 3/16/2018 12:10AM – Size: 29,145,220 KB
We recreated the Maintenance plan, thinking it could have gotten corrupt, but experienced the same issue.
Yesterday we disabled the maintenance plan completely to see what would happen. This morning we checked and could see that the phantom backup job ran again at 12am. But only one backup was there, since we disabled our maintenance plan completely.
We do not understand where this phantom job is coming from. The logs are showing that this phantom job is running a maintenance cleanup task and backing up the database. It shows the user that is running it (which is the same account that runs our current maintenance plan job), but the logs do not show from what server it’s coming from etc.
Kindly advise how we can find out where this backup job is coming from and kill it, as I said previously this has only started happening a few days ago.