Hi,

Am getting lots of failed jobs on an (Auto) SQL backup.  As databases are constantly being created and removed in this incidence it is failing all backup jobs when the new schedule is created after it has automatically checked for new db's.  Is there a way to change this so I don't end up with lots of failed jobs as the backup still takes place these are not really failed jobs.  As a result of this I have had to disable alerts or I get bombarded but 500+ emails every night.

Nick

• Edited by nickpeet15 23 hours 23 minutes ago more content

Modify protection group and un-tick Auto checkmark on SQL instance. This will stop adding newly added databases until you add them manually into protection groups.  

• Proposed as answer by Vijay MC 13 hours 9 minutes ago