HI all, in my company there is a SQL Server 2000, they ask me to make a backup plan for it, for example:
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.