Server Fault is a question and answer site for system and network administrators. 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

HI all, in my company there is a SQL Server 2000, they ask me to make a backup plan for it, for example:

database #1:

1- they want a complete backup every 15 days (done). 2- they want a differencial backup every 1 day (done). 3- they want a transac log backup every 1 hour (done). 4- they want to keep the data for 1 month (?). this mean that they don't care about losing the information of the last month, they wat to keep the information of the current month

I was thinking to make a full backup (every 1 month) of the data base that overwrite existing media to solve this requirement, and here is my question: Am I doing the right about overwrite the existing media?? Or there is another way??, Need some advice here.


share|improve this question
how big is the db? – Nick Kavadias Nov 27 '10 at 13:35

It would be helpful for you to understand the budget constraints within your company. Is copying each month's backup to permanent secondary storage (or offsite disaster recovery) an option?

As well, what data quality tasks are being performed on the database to balance the action of backup destruction?

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.