Backups keep failing?

I used the database maintenance wizard and choose most of the defaults.
Every night my backups fail because of the step to check data indexes and
repair any minor problems. The error I receive is [Microsoft][ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs to
be in single user mode. Does anyone know why this happeneds?
Thanks,
DanSee this page -
http://support.microsoft.com/default.aspx?scid=kb;en-us;290622
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Dan Marth" <danmarth@.earthlink.net> wrote in message
news:ux0ir6v2DHA.2408@.tk2msftngp13.phx.gbl...
> I used the database maintenance wizard and choose most of the defaults.
> Every night my backups fail because of the step to check data indexes and
> repair any minor problems. The error I receive is [Microsoft][ODBC SQL
> Server Driver][SQL Server]Repair statement not processed. Database needs
to
> be in single user mode. Does anyone know why this happeneds?
> Thanks,
> Dan
>|||Thanks, that seemed to clear things up!
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com> wrote in message
news:OTvHYUw2DHA.3196@.TK2MSFTNGP11.phx.gbl...
> See this page -
> http://support.microsoft.com/default.aspx?scid=kb;en-us;290622
> HTH
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Dan Marth" <danmarth@.earthlink.net> wrote in message
> news:ux0ir6v2DHA.2408@.tk2msftngp13.phx.gbl...
> > I used the database maintenance wizard and choose most of the defaults.
> > Every night my backups fail because of the step to check data indexes
and
> > repair any minor problems. The error I receive is [Microsoft][ODBC SQL
> > Server Driver][SQL Server]Repair statement not processed. Database needs
> to
> > be in single user mode. Does anyone know why this happeneds?
> >
> > Thanks,
> > Dan
> >
> >
>