February 16, 2010 at 11:08 pm
Can anyone tell me this error.
The job failed. The Job was invoked by Schedule 55 (User DB backup plan.Subplan_4). The last step to run was step 1 (backup transaction additional).
Thanks in Advance
February 16, 2010 at 11:15 pm
Whats the error shown in Step 1 of job..post it here
February 16, 2010 at 11:17 pm
JOB RUN: 'User DB backup plan.backup transaction additional' was run on 2/16/2010 at 5:00:00 PM
DURATION: 0 hours, 0 minutes, 14 seconds
STATUS: Failed
MESSAGES: The job failed. The Job was invoked by Schedule 55 (User DB backup plan.Subplan_4). The last step to run was step 1 (backup transaction additional).
This is the complete error showing
February 16, 2010 at 11:27 pm
Nope..this is not the error shown at step 1...this is error shown at step 0...Post the error shown at Step 1...
expand the Job history and look for the error at step 1
February 17, 2010 at 12:08 am
k2000.rajesh (2/16/2010)
Can anyone tell me this error.The job failed. The Job was invoked by Schedule 55 (User DB backup plan.Subplan_4). The last step to run was step 1 (backup transaction additional).
Thanks in Advance
rajesh,
See the sql server error log.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 17, 2010 at 4:41 am
If sqlserver database recovery model is in simple mode there is a chance to fail t-logbackup please let me know
February 17, 2010 at 4:41 am
in production
February 17, 2010 at 4:51 am
In step1 bpmc_cmd_costobject adjacencylist_postdeploy reported.
the process could not be created for step1 of job 08a9bc(reason the system cannot find the path specified)
please let me know
February 17, 2010 at 5:33 am
k2000rajesh (2/17/2010)
If sqlserver database recovery model is in simple mode there is a chance to fail t-logbackup please let me know
Answer is Yes...
You can't take the log backup while the database in simple mode
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 17, 2010 at 10:58 am
The transaction log for database 'database' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
Plz tell me what cause it will come
February 17, 2010 at 12:40 pm
You've fragmented the thread by posting this question in another forum: http://www.sqlservercentral.com/Forums/Topic867314-266-1.aspx. Follow Paul Randal's advice in that thread
Greg
February 17, 2010 at 12:47 pm
k2000rajesh (2/17/2010)
In step1 bpmc_cmd_costobject adjacencylist_postdeploy reported.the process could not be created for step1 of job 08a9bc(reason the system cannot find the path specified)
please let me know
If there's a backup statement in the step, I'd guess that the backup file can't be found. Can you post the contents of step1 so we can see the statement?
Greg
February 17, 2010 at 4:52 pm
Is anyone else confused? Are k2000.rajesh (the op) and k2000rajesh the same person?
Greg
February 17, 2010 at 11:28 pm
Greg Charles (2/17/2010)
Are k2000.rajesh (the op) and k2000rajesh the same person?
Hey rajesh is it true ?
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply