Log Shipping process running indefinatly
Jeff Randall
Posts: 41
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...
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
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
Was there any useful resolution?
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8