Re: Backup Job Notification Error

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 07/27/04


Date: Tue, 27 Jul 2004 07:43:29 -0400

Check to ensure it is the backup step which is failing... Often the step
PRIOR to backup fails... That would be doing the DBCC and having selected
"Repair" option.. This option requires the db to be in single-user mode. If
users are in the db, this step fails...

-- 
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
"Aboki" <hcokoli@yahoo.com> wrote in message
news:426301c4731f$6ac87900$a401280a@phx.gbl...
>
> I continue to receive a message alert that my backup job
> failed for three of my servers every morning while in the
> real sense the backups completed successfully. I did
> reboot one of the servers but this did not reslove the
> issue. Any help on this will be appreaciated please.