I have differential backups for multiple databases configured to run through a Stored Procedure. Sometimes one or more databases have not been backed up, even though the job was "successful".
I'm calling the backup through a Stored Procedure that runs scheduled in a job.
I have created the output file in the job, but it is not saying anything specific.
I've checked the SQL Server logs, event logs, changed the timings of the job, however I'm still not able to get the desired result nor any specific reason.
No recovery model change has happened.
The log backup Job is running fine without any issues.
SQL Server version is SQL Server 2008 R2 + SP1 on Windows Server 2008 R2.