Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to find a tape rotation strategy that would be optimal under the following conditions:

Backup Media Rotation strategy should support the following:

  1. Media Archives required every 28 days retained up to 3 years
  2. Require to recover to any point in time within past 7 days
  3. Can sustain up to 1 week gap in recovery time for next 4 weeks

I believe a good strategy would be to use the Grandfather-father-son strategy. However, I am unsure about point 3 above. Can someone explain what point three entails?

share|improve this question

migrated from Mar 16 '13 at 5:10

This question came from our site for professional and enthusiast programmers.

Hey Tim, Can the post be moved there? Or do you need to delete and so I repost? Cheers – bosra Mar 15 '13 at 23:46
It's 3/5 votes on the way to being migrated, so I think in another 15 minutes or so it should be done automatically. I don't have any power to move it myself. – Tim Mar 15 '13 at 23:55
Great stuff thanks – bosra Mar 16 '13 at 0:05
What exactly does "any point in time within past 7 days" mean? – Mike Sherrill 'Cat Recall' Mar 16 '13 at 12:58
Number 3 (plus number 2) seems to mean that, for the previous five weeks, requirement number 2 covers week 1, and they expect to retain one tape set per week for weeks 2 through 5. – Mike Sherrill 'Cat Recall' Mar 16 '13 at 13:01

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.