I have setup log shipping with standby mode to ship every 15 minutes, but when the log is restored on the secondary server it kills any currently executing queries.
Is it possible to setup the transaction log restore to start only after any currently running queries finish and to not allow any new connections to the secondary while the log is restoring?