up vote 0 down vote favorite
share [g+] share [fb]

Possible Duplicate:
SQL Server 2000 daily backup, need advice

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.

THANKS

link|improve this question
3  
This is not programming-related - belongs on serverfault.com where the DBA and sysadmins hang out - you'll get better answers there – marc_s Nov 26 '10 at 13:57
thanks, i'll pass my answer to serverfault.com – Kstro21 Nov 26 '10 at 15:13
feedback

migrated from stackoverflow.com Nov 26 '10 at 15:16

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

closed as exact duplicate by Chris S♦, Chris S♦ Feb 17 at 16:00

This question covers exactly the same ground as earlier questions on this topic; its answers may be merged with another identical question. See the FAQ for guidance on how to improve it.

2 Answers

up vote 0 down vote

Try this solutin sqlserveragent . If you cant use basic soft

link|improve this answer
feedback
up vote 0 down vote

I would ask for clarification on point #4 from the company. It is a bad idea to assume that they don't care about data over a month old. If you make that assumption, the company wants data from over a month ago (which is almost guaranteed to happen), and you don't have it they will likely be upset. Maybe what they meant was keep data up to a month old available online (not restore from tape), but again just ask - it will clear up the confusion.

link|improve this answer
feedback