Maintenance Plans

When you setup a maintenance plan to back up a database and you give it the
option to delete a database older than 1 day. Does it delete the old backup
before it creates the new backup?After. There's no setting for this, so you cannot change this behavior. Main
t plans are totally
reworked in 2005, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<Patricia> wrote in message news:OVpW%23yfFGHA.3936@.TK2MSFTNGP12.phx.gbl...
> When you setup a maintenance plan to back up a database and you give it th
e option to delete a
> database older than 1 day. Does it delete the old backup before it create
s the new backup?
>
>|||The clean up routines will run last unless you have edited the job and
changed the order.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
<Patricia> wrote in message news:OVpW%23yfFGHA.3936@.TK2MSFTNGP12.phx.gbl...
> When you setup a maintenance plan to back up a database and you give it
> the option to delete a database older than 1 day. Does it delete the old
> backup before it creates the new backup?
>
>