SQL Server 2005 Maintenance Plans - overwrite vs. append
10 pts.
0
Q:
SQL Server 2005 Maintenance Plans - overwrite vs. append
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
ASKED: Jul 16 2008  3:50 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Jul 16 2008  6:21 PM GMT by Mrdenny   46795 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   46795 pts.  |   Jul 16 2008  6:29PM GMT

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

 
0