Task not starting when started from particular time

[SaranyaK]

Hi all - I am trying to resume a task (SQL server source and target is Snowfake) from a specific date/time using Advanced options. As I start the task I see the "Starting Task" bar but it get stuck and not able to start the task. Any idea what is causing this (attached picture). Any idea what is causing this?

Also I see the below in logs

 [SOURCE_UNLOAD ]I: Calculated batch used for UNLOAD size is 1000 rows per fetch. (sqlserver_endpoint_unload.c:215)
 [SOURCE_UNLOAD ]I: Unload finished for table 'dbo'.'Application' (Id = 1). 0 rows sent. (streamcomponent.c:3616)

[Heinvandenheuvel]

The message shown are normal. The "0 rows sent" is expect for the 'fake load' for each table after start by timestamp. There is certainly more in the log. Download and look from the end backwards for something useful.

Are all Tlog backups available for the requested start time? That's a hard requirement. Is it not complaining it is waiting for the Tlog on UI or in the log?

You may want to verify you have a backup with a start date before the requested time.

Used SQL similar to the following:

select
        bs.backup_start_date,  bs.first_lsn,
        [dbo].[fn_NumericLsnToHexa](bs.first_lsn) "first_lsn - hex",
        [dbo].[fn_NumericLsnToHexa](bs.last_lsn) "last_lsn - hex",
        bs.backup_size/(1024*1024) "MB",
        bmf.physical_device_name
from msdb.dbo.backupmediafamily bmf, msdb.dbo.backupset bs
where   bmf.media_set_id = bs.media_set_id
and     bs.database_name=db_name() and bs.type='L'
and     bs.backup_start_date > getdate() - 5

You may also need to check the task settings for Tlog management.

Good luck,

Hein

[SaranyaK]

Thank you, this helps!!