Question

You maintain a log shipping configuration between a primary SQL Server instance and a secondary instance for disaster recovery. The primary server is still online and healthy, but you must perform a planned, controlled failover to the secondary as part of a datacenter migration with zero data loss. Which sequence of actions correctly performs the role change?

Accepted Answer

Manually back up the tail of the primary log with NORECOVERY, copy and restore all remaining logs including the tail on the secondary, then restore WITH RECOVERY and reconfigure log shipping in reverse.

Answer

Disable the copy and restore jobs on the secondary, then restore the secondary database WITH RECOVERY immediately.

Answer

Delete the log shipping configuration on the primary and detach the primary database before bringing the secondary online.

Answer

Fail the availability group over to the secondary replica and let synchronous commit guarantee no data loss.