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!!!
Software/Hardware used: BizTalk Server 2006/R2, MS SQL 2005