Backup Media Set Question

Posted on 2011-04-27
Medium Priority
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

Expert Comment

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

Accepted Solution

Alpesh Patel earned 2000 total points
ID: 35481535
Yes if you are taking full back up then no need to stay with older files.

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

850 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