I am trying to set up a monthly full backup and a daily differential. The full backup is currently on the 1st, but I might change it to the first Saturday. I need to retain full backups for a few months (multiple sets).
My question is: on the first of the month how can I prevent the differential backup from running? I don't want them both going at the same time, or the differential to run based on a previous full...if that makes sense.
Is there a way to exempt certain days of the week or month from the differential schedule? I wasn't able to find any way to do that in the Maintenance Plan Wizard...
This is on SQL Server 2012 Enterprise