Post reply

Overwrite media

  • October 3, 2007 at 6:25 am

    #118738

    Using SQL Server 2005 standard edition.

    Will someone please explain when to choose 'append to the existing backup set' or 'overwrite all existing backup sets' for the Overwrite media backup option.

    This is for a full backup.

  • October 3, 2007 at 8:58 pm

    #738915

    Think of a backup set as essentially a file. You can overwrite, meaning essentially delete and recreate the file. Or you can append, which means add a second set of data to the file.

    I don't know many people that still use backup sets. Most people tend to backup to a specific file, naming them with the timestamp.

  • October 4, 2007 at 8:24 am

    #739103

    Thanks, Steve. Very helpful.

  • October 4, 2007 at 8:48 am

    #739124

    You are welcome and please feel free to ask more questions.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply