MarkAndBackupLog step in BizTalk SQL Agent backup job is failing – says db_MarkAll SP is missing!!

5 pts.
Tags:
BizTalk
BizTalk db_MarkAll
Microsoft BizTalk Server
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
ASKED: August 20, 2009  6:21 PM
UPDATED: September 21, 2009  10:43 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

That stored procedure will have been written by someone at your company. It isn’t provided by Microsoft.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Yakov72
    Just to add, I guess somebody mistyped 'dbo.' (dbo.sp_MarkAll)
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following