Sql-server – Accumulated logs – Log shipping SQL Server

high-availabilitylog-shippingsql server

If I have a log shipping scenario where a report runs for 30 minutes and the log shipping is set up for not killing the connection, and because of that, the restore will fail, the question is if all the accumulated transaction logs will be restored the next time the db is available for that (no connections open) ?

Best Answer

The log-shipping process includes 3 steps.

  1. T-Log backup of the primary database
  2. Copy the backup file to the target destination (shared)
  3. 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 & 2 (backup & 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!

Related Question