Yakov72 
10 pts. | Sep 21 2009 10:43PM GMT
Just to add, I guess somebody mistyped ‘dbo.’ (dbo.sp_MarkAll)
Q:
MarkAndBackupLog step in BizTalk SQL Agent backup job is failing - says db_MarkAll SP is missing!!
I have activated the first of BizTalk SQL Agent jobs to backup all my BizTalk databases.
The second step of this daily backup (MarkAndBackupLog) is failing.
The first step (full backup) runs once a day at 4 AM and is succeeding.
And the 3rd step of the backup job (clear history) is succeeding.
But the second step that deals with the DB log is failing.
The second step (MarkAndBackupLog) is set up as a recurring job under SCHEDULE and is running once every 15 minutes after 4 AM after the step 1 (full backup) runs.
This second step is failing, saying that dba-sp_MarkAll SP is not found! I found a piece of code that tries to add the db_MarkAll SP back into MgmtDb, but when I execute it, iut says db_MarkAll is already in the Mgmt DB!!!
any ideas?
Thanks,
Ben
Software/Hardware used:
BizTalk Server 2006/R2, MS SQL 2005
The second step of this daily backup (MarkAndBackupLog) is failing.
The first step (full backup) runs once a day at 4 AM and is succeeding.
And the 3rd step of the backup job (clear history) is succeeding.
But the second step that deals with the DB log is failing.
The second step (MarkAndBackupLog) is set up as a recurring job under SCHEDULE and is running once every 15 minutes after 4 AM after the step 1 (full backup) runs.
This second step is failing, saying that dba-sp_MarkAll SP is not found! I found a piece of code that tries to add the db_MarkAll SP back into MgmtDb, but when I execute it, iut says db_MarkAll is already in the Mgmt DB!!!
any ideas?
Thanks,
Ben
Software/Hardware used:
BizTalk Server 2006/R2, MS SQL 2005
ASKED:
Aug 20 2009 6:21 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
Based on the information in your question, the job is trying to run db_MarkAll, but the stored procedure in the database is dba-sp_MarkAll. Seams like the names don't match, and that's probably you problem.
