I am currently doing weeday differential backups on SQL and Weekend Full
If someone creates a new database on a Monday, the jobs report failed for the rest of the week until I get a full backup of the new database.
The exact error is:
Cannot perform a differential backup for database 'ReportServer', because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.
Is it possible to force a full backup if one doesn't exist?
If not, is it possible to have it not report the job as failed?