[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Which 'back up to the existing media set' should I use?

Posted on 2009-04-26
1
Medium Priority
?
215 Views
Last Modified: 2012-05-06
Hi,

I need to create a backup file for a database.  I am trying to do this using SQL Server Mgmt. Studio.  I know that I need to use Back up to the existing media set option, but not sure which option I should take between 'Append to the existing backup set' and 'Overwrite all existing backup sets'.   I remember that one of DBAs recommended me to use 'Overwrite all existing backup sets' before.  However, I want to make sure that it is the right choice.  
Can anybody explain the difference between two and when to use each option?
0
Comment
Question by:IzzyTwinkly
1 Comment
 
LVL 27

Accepted Solution

by:
Chris Luttrell earned 1500 total points
ID: 24239495
These two articles describe what the two types mean and are more often used when doing backups to tape backups or some kind of media like that.  Most people do backups to disk and Name the different backups so the DBA recommendation to use Overwrite is pretty common and should probably work for you unless you are writing to tape.
http://msdn.microsoft.com/en-us/library/ms191505(SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms191211(SQL.90).aspx
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Loops Section Overview
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

834 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