Accumulated logs - Log shipping SQL Server
The log-shipping process includes 3 steps.


T-Log backup of the primary database
Copy the backup file to the target destination (shared)
Restore to the target database with standby or no-recovery.


If we use stand-by, there are 2 option available disconnect user or go without disconnecting it. If we don't disconnect active sessions restore wouldn't begin until there's no active connection with the database.

In this case, steps 1 &amp; 2 (backup &amp; copy) will execute normally but restore will fail.

The log-shipping process wouldn't delete any backup file until it's older than the defined threshold.

Once there's no connection with the database it will restore all transaction log file greater then last LSN.

Thanks!