|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Backup job reported as faileddatabases 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. Perhaps you can find some details if you specify a report file for the plan and investigate that
file? -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "BlackToe" <goo***@tripletreesoftware.com> wrote in message news:1191777184.181970.184540@k79g2000hse.googlegroups.com... > 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. > On Oct 7, 12:45 pm, "Tibor Karaszi"
<tibor_please.no.email_kara***@hotmail.nomail.com> wrote: Show quote > Perhaps you can find some details if you specify a report file for the plan and investigate that I'll give that a shot. Here's some more information that may or may> file? > > -- > Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi > > "BlackToe" <goo***@tripletreesoftware.com> wrote in message > > news:1191777184.181970.184540@k79g2000hse.googlegroups.com... > > > > > 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.- Hide quoted text - > > - Show quoted text - not be helpful: In the "Maintenance Plan" node of the log viewer: 1) There are green checkmarks next to each entry for "Nightly backup" 2) There are two identical entries for each time the plan was executed 3) The duration on all is listed as "00:00:00" In the "Job History" node of the log viewer: 1) Every entry has a red X next to it. 2) There is only one entry for each time the job was run. 3) The duration is between 1:40 and 1:50 (i.e. < 2 minutes) for each entry BlackToe (goo***@tripletreesoftware.com) writes:
Show quote > Using the wizard, I set up a maintenance plan to backup a few In the job history for 'Nightly backup' is that job listed as passed > 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. or failed? Have you look at the step details? -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx On Oct 7, 2:55 pm, Erland Sommarskog <esq***@sommarskog.se> wrote:
Show quote > BlackToe (goo***@tripletreesoftware.com) writes: The job history lists the job as failed. When I expand the step> > 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***@sommarskog.se > > 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 - details, there is only one additional level (step name = "Subplan"), and the message is "The package execution failed. The step failed".  |
|||||||||||||||||||||||
Other interesting topics