I have setup a job that runs every night and makes a full backup of all databases on the server. During the day, another job makes differential backups every few hours.
The problem comes when a new database is created. The differential backup job fails every time, until the full backup job runs for the first time since the database was added. After that, everything runs as expected, at least until another new database is added.
Of course, a differential backup doesn't make sense when there's no full backup yet, and I'm assuming that's why I'm getting an error.
Question is, is there something I can do do prevent this, preferably something that won't require manual action every time a new database is added?