Database Maintenance Plan

Hi All,
I have a built a Database Maintenance Plan for my databases which includes
the following...
Intra-daily:
Transactional Backup Script
Daily:
Differential Backup Script
Weekly:
CheckDB Script
IndexDefrag/Reindex Script
Full Backup Script
Backup MSAS DB Script
Monthly:
Check Login Script (LDAP Query Script checks for changes to Windows Groups)
Clear old Backup History Script
Is there anything else anybody has, that they find useful as part of their
DB Maintenance Plans? I still run the CheckDBs more out of habit than
anything else, does anyone else still run it?You didn't specify what version of SQL Server, so I assume 2000.
You mentioned weekly IndexDefrag/Reindex. I take it that you only do one of these operations, or
that you conditionally do only one of the operations per index. Also, don't defrag if the data isn't
fragmented in the first place (maint wiz doesn't take this into account). See for instance
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
> I still run the CheckDBs more out of habit than
> anything else, does anyone else still run it?
Yes, and I try to run int even more often. In the unlikely (but unfortunate) case of a corruption, I
can restore the most recent clean backup and then restore all subsequent log backup. The fewer log
backups I have, the more likely that the corruption will *not* re-appear when I restore them. I.e.,
of you have a problem in the database, you want to know ASAP.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"BenUK" <BenUK@.discussions.microsoft.com> wrote in message
news:9F683BA8-999D-424F-909C-8782747F683A@.microsoft.com...
> Hi All,
> I have a built a Database Maintenance Plan for my databases which includes
> the following...
> Intra-daily:
> Transactional Backup Script
> Daily:
> Differential Backup Script
> Weekly:
> CheckDB Script
> IndexDefrag/Reindex Script
> Full Backup Script
> Backup MSAS DB Script
> Monthly:
> Check Login Script (LDAP Query Script checks for changes to Windows Groups)
> Clear old Backup History Script
> Is there anything else anybody has, that they find useful as part of their
> DB Maintenance Plans? I still run the CheckDBs more out of habit than
> anything else, does anyone else still run it?|||Yep, sorry, it's 2000...
...my maintenance plan is all done via scripts/jobs as opposed to the maint
wiz, the InDefrag/Reindex is a conditional operation based on Logical
Fragmentation and Page Density and is based on the level of fragmentation in
each...
"Tibor Karaszi" wrote:
> You didn't specify what version of SQL Server, so I assume 2000.
> You mentioned weekly IndexDefrag/Reindex. I take it that you only do one of these operations, or
> that you conditionally do only one of the operations per index. Also, don't defrag if the data isn't
> fragmented in the first place (maint wiz doesn't take this into account). See for instance
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
>
> > I still run the CheckDBs more out of habit than
> > anything else, does anyone else still run it?
> Yes, and I try to run int even more often. In the unlikely (but unfortunate) case of a corruption, I
> can restore the most recent clean backup and then restore all subsequent log backup. The fewer log
> backups I have, the more likely that the corruption will *not* re-appear when I restore them. I.e.,
> of you have a problem in the database, you want to know ASAP.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "BenUK" <BenUK@.discussions.microsoft.com> wrote in message
> news:9F683BA8-999D-424F-909C-8782747F683A@.microsoft.com...
> > Hi All,
> >
> > I have a built a Database Maintenance Plan for my databases which includes
> > the following...
> >
> > Intra-daily:
> > Transactional Backup Script
> >
> > Daily:
> > Differential Backup Script
> >
> > Weekly:
> > CheckDB Script
> > IndexDefrag/Reindex Script
> > Full Backup Script
> > Backup MSAS DB Script
> >
> > Monthly:
> > Check Login Script (LDAP Query Script checks for changes to Windows Groups)
> > Clear old Backup History Script
> >
> > Is there anything else anybody has, that they find useful as part of their
> > DB Maintenance Plans? I still run the CheckDBs more out of habit than
> > anything else, does anyone else still run it?
>
>