Re: Backup job reported as failed

Perhaps you can find some details if you specify a report file for the plan and investigate that file?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"BlackToe" <google@xxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1191777184.181970.184540@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Using the wizard, I set up a maintenance plan to backup a few
databases in MS SQL Server 2005. The plan does:

1) Integrity check
2) Database shrink
3) Rebuilds indexes
4) Backs up the databases
5) Deletes old backup files

I also configured Database Email and SQL Agent to run the plan nightly
and email me the results. The email states that the job is failing:

JOB RUN: 'Nightly backup' was run on 10/7/2007 at 2:00:00 AM
DURATION: 0 hours, 1 minutes, 44 seconds
STATUS: Failed
MESSAGES: The job failed. The Job was invoked by Schedule 1 (Nightly
backup). The last step to run was step 1 (Subplan).

However, the backups all appear to be made correctly, and the log file
shows no errors. I also can't get any detail from the Job History to
determine exactly what is failing.

Thanks in advance for any help.


.

Relevant Pages

  • Re: Slow UPDATE and DELETE on SQL Server 2000
    ... databases: one on the new machine and one on the old machine (by the ... The plan from the old machine was more complex and has PARALLELISM ... > wrong with the SQL Server installation and unlikely that there are sub-system ... > linked-server driver parameters are not properly set. ...
    (microsoft.public.sqlserver.server)
  • Re: Backup job reported as failed
    ... databases in MS SQL Server 2005. ... Deletes old backup files ... In the job history for 'Nightly backup' is that job listed as passed ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
    (microsoft.public.sqlserver.tools)
  • Re: Backing Up Mirrored database
    ... Tibor Karaszi, SQL Server MVP ... > all databases; and both run successfully without any issues. ... "Attempt to backup but receives an error message from the engine so the job fails"? ...
    (microsoft.public.sqlserver.tools)
  • Re: Automating SQL Service start and shut down
    ... The best option would be using the Transact-SQL BACKUP command. ... make sure that you know how to restore/recover your data and your databases. ... Grab a tape, restore the files to a different server, and try to get the files restored. ... Moving SQL Server databases to a new location with Detach/Attach ...
    (microsoft.public.sqlserver.setup)
  • Re: Sharepoint DB maintenance?
    ... options to backup nightly. ... I am more concerned abouthe maintenance (i.e. SQL maintenance?) stuff. ... It's a good idea to back up the SPS databases regularly. ... on the server that is running SQL Server 2000." ...
    (microsoft.public.sharepoint.portalserver)