Backup Maintenance Plan show "success", but it does not generate any file
-
Hi All,
My Backup Maintenance Plan usually generate a file with the database name and date (BAK)
in a folder and I normally monitor the Jobs Execution and the files generated but last week
simply it does not work.
It means all jobs say "success" in the correct schedule, but it does not generate any file and
I don't know why even when I execute the maintenance plan manually say "Success" but the
time execution is so fast and it does not generate any file backup.. even I also have tried with
the "sa" from the same SQL server with an account "Domain Admin" and nothing.
Actually Im running manually in Query Analyzer the SQL-Code generated from "Backup Maintenance Plan"
I would like to know if someone has had the same issue and some idea how to fix it.
Thanks,
-
If you an output file in the job step it would give more details regarding the job status. If you don't have output file in job step, I would suggest you to do it, this could be helpful to detect further.
M&M
-
When I see the message history say:
------------------------------------
Message
The job succeeded. The Job was invoked by Schedule 23 (MP - Respaldo Diario.Diario). The last step to run was step 1 (Diario).
------------------------------------
And this information.
Date06/07/2011 12:01:00 a.m.
LogJob History (BKP - MP - Respaldo Diario.Diario)
Step ID0
ServerSSVSSSVR003
Job NameBKP - MP - Respaldo Diario.Diario
Step Name(Job outcome)
Duration00:00:00
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
-
That's the job history, not the MP history.
I'd make sure your plan is set to generate a log. Usually these are in the SQL folders in \LOG, so check them for more information.
Can you also run a trace/profiler to see what happens when you execute this as the plan or in SSMS?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply