Maintenance Plan

I am a newbie at this but I am a quick learner.
I am trying to setup a maintenance plans for both my Local
and Sharepoint instances of SQL 2000 SP3. When I set the
plans I enabled most every feature (obviously a newbie).
Needless to say, the maintenance plans failed on a couple
issues 1) "Attempt to repair any minor problems",
2) "Tansaction log backups".
I understand that if I disable the first item, it will
work - but what if I would like it to repair any minor
errors before it backed-up?
I also understand if I do not back-up the transaction logs
I will have problem rebuilding if necessary. It appears
that I should be able to invoke a couple of commands on
the SQL Server Agent\Jobs\Steps section to temporarily set
mode to single-user, then backup, then reset back to prior
state; Is this the way to go?
Or how can I enable both of these features?
Or do I need some serious help on this?
I appreciate any help I can get on this.
Paul
Things to remember - the 'Fix Minor Problems' select will require exclusive access to the database, so if you have attached users it will fail. Most likely you will want to run without this option, and review the logs daily to see if there are errors that
need fixing.
Also if you are running against all databases then transaction logs backups will fail, since there are system databases (MSDB, Master) that are set to simple recovery mode (ie they truncate the transaction log on checkpoints). You might want to consider u
sing a seperate plan for 'User Databases' to perform transaction log backups.
Kevin
Kevin Madsen
"Paul" wrote:

> I am a newbie at this but I am a quick learner.
> I am trying to setup a maintenance plans for both my Local
> and Sharepoint instances of SQL 2000 SP3. When I set the
> plans I enabled most every feature (obviously a newbie).
> Needless to say, the maintenance plans failed on a couple
> issues 1) "Attempt to repair any minor problems",
> 2) "Tansaction log backups".
> I understand that if I disable the first item, it will
> work - but what if I would like it to repair any minor
> errors before it backed-up?
> I also understand if I do not back-up the transaction logs
> I will have problem rebuilding if necessary. It appears
> that I should be able to invoke a couple of commands on
> the SQL Server Agent\Jobs\Steps section to temporarily set
> mode to single-user, then backup, then reset back to prior
> state; Is this the way to go?
> Or how can I enable both of these features?
> Or do I need some serious help on this?
> I appreciate any help I can get on this.
> Paul
>