Backup Media Set Question
Posted on 2011-04-27
I have just been put in charge of a SQL Server 2005 database. (My experience has been with Oracle).
I have a question with regards to media set backups. Should I start a new media set periodically? I see that backups are appended to a previous media set.
I take it that you don't need a full media set to recover a database. For example, if I take a full backup every Saturday, I don't need the previous backups in the same media set to recover. Please correct me if I am wrong.
Backup Schedule is tenatively as follows: - Full Backup Every Saturday
- Differential Backup every day
- Transaction log backup every hour.
If I do a full backup on Saturday and append it to a previous media set, I won't need the previous file(s) of the same media set (taken before Saturday) to recover on let's say Tuesday.
Once again, Please correct me if I am wrong.