Peter Kryszak (2/6/2006)
I agree with your point that the "permissions options" are valid issues especially when best practices were mentioned.
I think the point of the question was that best practices, as implemented in the wizard, are not complete and require some additional steps to create a practical backup process.
Maybe, but wouldn't best practises also include ensuring that permissions were correct, and ensuring that the requirement for these permissions was documented in such a way that future changes would take it into account?
Given that best practises clearly were no followed, I just went for the most obvious failure. I've had a junior person do that to one of my customers, and another do it to an in-house system; both were on Sql 2000 not on Sql 2005 but the principle is no different. I've never seen a disc filled by old backups through missing delete permissions. So it seems clear to me what the most obvious is, and I agree with the officially correct answer.