63,630 pts.
POSTED: Sep 21, 2009 10:43 PM (GMT)
Just to add, I guess somebody mistyped ‘dbo.’ (dbo.sp_MarkAll)
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
UPDATED:
September 21, 2009 10:43:22 PM GMT
RELATED QUESTIONS
- Database restore
- BizTalk interview Questions
- Using stored Procedure in SSRS
- xml handling on AS400
- Server Timeout on initial web connection to SQLServer
- update the tables in to two server using a single ssis package
- Don't run the SQL Server Account as Local Administrator or member of the Administrator Group?
- moving an existing active/passive 2005 SQL cluster onto an existing active/active SQL 2008 cluster.
- Full and differential backup size same in SQL Server
- Error backing up with SAP transaction DB13
Answer Wiki:
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.
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.
To see other answers submitted to the Answer Wiki View Answer History.
