Is it possible to use the maintenance plan wizard to create a backup plan that takes a full backup on a Sunday and incremental every other day of the week. I cant see a way to do this but am perhaps missing something obvious. If it cant be done would the best method be just to schedule jobs containing the t-sql commands?
The question I am asking is how do you tell the maintenance plan to do an incremental every day except Sunday when you want a full backup? I cannot see any way of specifying full or incremental when I create the job, it seems to default to full. As I say perhaps I am missing something obvious, it seems strange that it cant be done?