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.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
If the database is in standby, you can read from it. Is it in Standby?
No it's in Non recovery mode
Answers Answers and Comments
19 People are following this question.
Log shipping - high IO and 30GB MSDB
backup transfer on ftp
Need Suggestion for Setting SQL Server(s)
How to suppress rowversion?
How to set up Monitor Server After Setting up Log Shipping