| jeremy 2005-08-29, 5:56 pm |
| I am trying to run the sql agent job "Backup BizTalk Server". When I run the
job as sa, step 1 completes sucessfully backing up the databases, but step 2
is failing while trying to perform the log marking with the following
errors/warnings shown below. Anyone have any ideas as to how to further
explore what the issues seems to be? The destination file path is correct
and has appropraite access.
Event Type: Warning
Event Source: SQLAgent$BTSA
Event ID: 208
Description:
SQL Server Scheduled Job 'Backup BizTalk Server'
(0x55A06B778323BF489509A337B5093AC4) - Status: Failed - Invoked on:
2005-08-29 22:00:01 - Message: The job failed. The Job was invoked by
Schedule 24 (MarkAndBackupLogSched). The last step to run was step 2
(MarkAndBackupLog).
----------------------------------------------------------------------------
Event Type: Error
Event Source: MSSQL$BTSA
Event ID: 17055
Description:
3041 :
BACKUP failed to complete the command exec [dbo].[sp_MarkAll] 'BTSA' /* Log
mark name */, 'E:\DATA\SQL_Support\SG0\MSSQL$BTSA\sqlb
kup\BizTalk\LogMark' /*
location of backup files */
|