DB Maintainance Plan

HI
I have shedules a complete backup using DB maintainance plan and checked option to Remove files older than 1 day
Questions - Does file get removed after new backup is done or before the new backup starts
Also, what happens in case DB Consistency check fails in the Integrity tab, does backup still goes through ?
Thanks
Sanjay
The Delete happens after the backup completes. I believe the DBCC is a
separate job altogether but you should confirm this on your system.
Andrew J. Kelly SQL MVP
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:8934B2F8-1980-4FA3-B2AE-D5CDBD7329AE@.microsoft.com...
> HI
> I have shedules a complete backup using DB maintainance plan and checked
option to Remove files older than 1 day
> Questions - Does file get removed after new backup is done or before the
new backup starts
> Also, what happens in case DB Consistency check fails in the Integrity
tab, does backup still goes through ?
> Thanks
> Sanjay
>
>
|||I think the files get removed as the last step... And if DBCC fails from the
previous tab (when it is NOT included in the full db backup), it does not
prevent the backup from occurring...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:8934B2F8-1980-4FA3-B2AE-D5CDBD7329AE@.microsoft.com...
> HI
> I have shedules a complete backup using DB maintainance plan and checked
option to Remove files older than 1 day
> Questions - Does file get removed after new backup is done or before the
new backup starts
> Also, what happens in case DB Consistency check fails in the Integrity
tab, does backup still goes through ?
> Thanks
> Sanjay
>
>
|||I beleive there was a problem with "Attempt to repair minor problems" in Optimization tab in SQL server
Is that still a problem and we shoudnt use it ?
"Wayne Snyder" wrote:

> I think the files get removed as the last step... And if DBCC fails from the
> previous tab (when it is NOT included in the full db backup), it does not
> prevent the backup from occurring...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
> news:8934B2F8-1980-4FA3-B2AE-D5CDBD7329AE@.microsoft.com...
> option to Remove files older than 1 day
> new backup starts
> tab, does backup still goes through ?
>
>
|||It was a problem in that it put the database in single user mode and left it
there. You should not have the MP automatically "Fix" the database. If
there is a problem you should determine what is is and what the best coarse
of action is and also determine why there was a problem in the first place.
That option should have been removed a long time ago in my opinion.
Andrew J. Kelly SQL MVP
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:608CE6D4-455A-489E-9AF6-103C853E0A4B@.microsoft.com...
> I beleive there was a problem with "Attempt to repair minor problems" in
Optimization tab in SQL server[vbcol=seagreen]
> Is that still a problem and we shoudnt use it ?
>
> "Wayne Snyder" wrote:
the[vbcol=seagreen]
not[vbcol=seagreen]
checked[vbcol=seagreen]
the[vbcol=seagreen]