How can we help you today? How can we help you today?

Log Shipping process running indefinatly

DBCC xp_sqlbackup(FREE)
Go

DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master..sqlbackup N'-sql "RESTORE LOG [SOY_usc001prd] FROM DISK = ''\\Server\d$\SQLBackups\SOY_usc001prd_*.sqb'' WITH STANDBY = ''d:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\UNDO_SOY_usc001prd.DAT'', MAXTRANSFERSIZE = 524288, MOVETO = ''\\Server\d$\SQLBackups\Atlanta''"', @exitcode OUTPUT, @sqlerrorcode OUTPUT
IF (@exitcode <>0) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup job failed with exitcode: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
END
Go


The process runs forever (until I kill it), but does not seem to be processing any log files. Currently it has been running 23 hours, without processing a single log file, or giving an error...
Jeff Randall
0

Comments

3 comments

Sort by
  • petey
    Pls see private message. Thanks.
    petey
    0
  • RichardB
    This sounds like an issue I have recently had.

    Was there any useful resolution?
    RichardB
    0
  • petey
    A couple of the transaction log files did not contain LSN information in it's header, causing the restore to fail.
    petey
    0

Add comment

Please sign in to leave a comment.