Home > IT Answers > SQL Server > SQL Server 2005 Maintenance Plans - overwrite...
Help

Question

  Asked: Jul 16 2008   3:50 PM GMT
  Asked by: Cecrane

SQL Server 2005 Maintenance Plans - overwrite vs. append


SQL Server administration, SQL Server 2005

I am trying to create a maintenance plan, but when I use the backup database widget, it defaults to 'append existing...'. I want 'oversrite existing...'. Can anyone help me find where that is set?

Thank you
Carla

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Jul 16 2008  6:21 PM GMT  by Mrdenny




That option is only available when you select to backup the database or databases to a single file, or to a backup stripe. If you leave the default "Create a backup for every database" selected this option does not apply.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   Jul 16 2008  6:29PM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.