SQL Server Management Studio 2019 backup schedule rogue backup file
Hello,
I have a backup schedule which runs Mon-Fri at 21:00 performing a full backup of the selected database in the maintenance schedule.
The backup works fine and we can restore from this ok.
The problem is a rogue backup file is being created and then its appended to every time the schedule runs. The backup file created is named the same as an initial backup we took when we first installed the database so I am guessing there is reference to this in the database somewhere which then creates this file on schedules. Please can you advise how i could stop this happening?
Thanks
Gary
Hello, I have a backup schedule which runs Mon-Fri at 21:00 performing a full backup of the selected database in the maintenance schedule. The backup works fine and we can restore from this ok. The problem is a rogue backup file is being created and then its appended to every time the schedule runs. The backup file created is named the same as an initial backup we took when we first installed the database so I am guessing there is reference to this in the database somewhere which then creates this file on schedules. Please can you advise how i could stop this happening? Thanks Gary Read More