Re: Backup Job Notification Error
From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 07/27/04
- Next message: Mark Allison: "Re: Generating Record number for a result set?"
- Previous message: Pavils Jurjans: "Query help please"
- In reply to: Aboki: "Backup Job Notification Error"
- Messages sorted by: [ date ] [ thread ]
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.
- Next message: Mark Allison: "Re: Generating Record number for a result set?"
- Previous message: Pavils Jurjans: "Query help please"
- In reply to: Aboki: "Backup Job Notification Error"
- Messages sorted by: [ date ] [ thread ]