What are the challenges you face when working across database platforms? Take the survey
Options

Log Shipping process running indefinatly

Jeff RandallJeff Randall Posts: 41
edited October 3, 2006 10:08PM in SQL Backup Previous Versions
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...

Comments

Sign In or Register to comment.