2

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?

0

1 Answer 1

4

But it possible to setup to restore transaction log after finish of current running and this interval time no other user connect secondary database.

Yes it's possible, you can read more about it here: Using Secondary Servers for Query Processing

enter image description here

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.