Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
    
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
1  
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
1  
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
add comment

migrated from stackoverflow.com Mar 16 '13 at 5:10

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

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.