I'd like to setup a backup to run every week, but set it to expire after *two* weeks, with the idea that if it can't over-write last week's it'll skip to the two-weeks-ago file. Is that possible? I'm running into trouble with init+noskip - the backup isn't running until it's too late. I guess I really just don't understand how/why MSSQL works the way it does.
Many thanks