question

Vahe avatar image
Vahe asked

log shipping

I have log shipping on my server, and according to that my secondary database is in stanby or non recovery state, but somehow I can still connect to that database and even make selects. Can anyone explain why. I'm using Sql Server 2016.

log-shipping
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM commented ·

If the database is in standby, you can read from it. Is it in Standby?

0 Likes 0 ·
Vahe avatar image Vahe commented ·

No it's in Non recovery mode

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.