Re: DB Maintainance Plan
From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 07/30/04
- Next message: Andrew J. Kelly: "Re: Restoring Server which utilizes Log Shipping"
- Previous message: Wayne Snyder: "Re: The server was unable to add the virtual root"
- In reply to: Sanjay: "DB Maintainance Plan"
- Next in thread: Sanjay: "Re: DB Maintainance Plan"
- Reply: Sanjay: "Re: DB Maintainance Plan"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 30 Jul 2004 13:57:52 -0400
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 > > >
- Next message: Andrew J. Kelly: "Re: Restoring Server which utilizes Log Shipping"
- Previous message: Wayne Snyder: "Re: The server was unable to add the virtual root"
- In reply to: Sanjay: "DB Maintainance Plan"
- Next in thread: Sanjay: "Re: DB Maintainance Plan"
- Reply: Sanjay: "Re: DB Maintainance Plan"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
