Thank you very much for your response.

Here is the actual procedure that recovers the log file;

use master

if exists (SELECT * from sysobjects where id = object_id('dbo.sp_ApplyStandByLog') and sysstat & 0xf = 4)

drop procedure dbo.sp_ApplyStandByLog

GO

CREATE PROCEDURE sp_ApplyStandByLog

@DBName sysname,

@BackupFileName nvarchar(256),

@UndoFile nvarchar(256)

AS

DECLARE @RestoreCmd nvarchar(510)

DECLARE @ErrDesc nvarchar(510)

SET @RestoreCmd =

'RESTORE LOG ' + @DBName

+ ' FROM DISK=''' + @BackupFileName

+ ''' WITH STANDBY=''' + @UndoFile

PRINT 'Executing ' + @RestoreCmd

RESTORE LOG @DBName FROM DISK=@BackupFileName WITH STANDBY=@UndoFile

IF @@ERROR <> 0

BEGIN

SET @ErrDesc =

'sp_ApplyStandByLog Error ' + convert(varchar(9),@@Error) + ' occurred on '

+ 'database %s restoring backup file %s'

RAISERROR (@ErrDesc,19,1,@DBName, @BackupFileName)

END

RETURN

Here is the error message from the job history;

Executed as user: BRANCHSERVER1\BackupAdmin. ...TE 42000] (Error 601) Processed 1 pages for database 'failsafe', file 'failsafe_Log' on file 1. [SQLSTATE 01000] (Error 4035) Processed 696 pages for database 'failsafe', file 'failsafe_Data' on file 1. [SQLSTATE 01000] (Error 4035) Executing RESTORE FULL BACKUP failsafe FROM DISK='\\branchserver2\e$\backup\failsafe_001_000003768_20130218_1014_FULL.bak' WITH STANDBY='e:\backup\failsafe_undo.dat, REPLACE [SQLSTATE 01000] (Error 0) RESTORE DATABASE successfully processed 697 pages in 4.316 seconds (1.321 MB/sec). [SQLSTATE 01000] (Error 3014) Could not continue scan with NOLOCK due to data movement. [SQLSTATE 42000] (Error 601) Processed 1 pages for database 'ngricao', file 'NGRICAO_Log' on file 1. [SQLSTATE 01000] (Error 4035) Processed 287544 pages for database 'ngricao', file 'NGRICAO_Data' on file 1. [SQLSTATE 01000] (Error 4035) Executing RESTORE FULL BACKUP ngricao FROM DISK='\\branchserver2\e$\backupgricao_001_000003395_2013... The step failed.

Thank you