Home > IT Answers > SQL Server > SQL Server 2005 Maintenance Plans – overwrite vs. append
Cecrane
10 pts.
 SQL Server 2005 Maintenance Plans – overwrite vs. append
SQL Server 2005, SQL Server administration
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

Software/Hardware used:
ASKED: July 16, 2008  3:50 PM
UPDATED: July 16, 2008  6:29 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  July 16, 2008  6:21 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

Denny Cherry
 64,550 pts.