Can I force a SQLfull backup on diff job if a full doesn't exist
Posted on 2005-04-07
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?