Backup Media Set Question

Posted on 2011-04-27
Last Modified: 2013-11-05
Hi Everyone,

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.

Thanks Everyone,
Question by:jonsuns7
    LVL 9

    Expert Comment

    Always It is full back up first time and the rest are partial backup.
    LVL 21

    Accepted Solution

    Yes if you are taking full back up then no need to stay with older files.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Suggested Solutions

    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now