• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 219
  • Last Modified:

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

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
IzzyTwinkly
Asked:
IzzyTwinkly
1 Solution
 
Chris LuttrellSenior Database ArchitectCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now