Re: Backup job reported as failed

On Oct 7, 2:55 pm, Erland Sommarskog <esq...@xxxxxxxxxxxxx> wrote:
BlackToe (goo...@xxxxxxxxxxxxxxxxxxxxxx) writes:
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.

In the job history for 'Nightly backup' is that job listed as passed
or failed? Have you look at the step details?

--
Erland Sommarskog, SQL Server MVP, esq...@xxxxxxxxxxxxx

Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx- Hide quoted text -

- Show quoted text -

The job history lists the job as failed. When I expand the step
details, there is only one additional level (step name = "Subplan"),
and the message is "The package execution failed. The step failed".

.

Relevant Pages

  • 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: Scheduling a Daily Backup of a SQL Database
    ... history for the job step usually has some more details. ... as if they are only set to SIMPLE you just need to backup the database. ... have found out how to backup ypur databases, you should be sure that you are ... SQL Server 2008 Standard for its database. ...
    (microsoft.public.sqlserver.server)
  • 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)
  • Re: Backups failing
    ... You may need to look at both the job history (make sure to view step ... >I am running SQL-2000 Standard and have created a backup job a while ... > back to back up several databases, and a seperate job to backup ... Where can I look to see why it is failing? ...
    (microsoft.public.sqlserver.server)