Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

2
  • Thanks. "Standby" mode looks promising, but I've read something that suggest it can introduce some slowdown when restoring; given that I'll hopefully be restoring the log files into place every few minutes, and the secondary database will be used semi-regularly for reporting, should I expect any problems with performance or have to worry about connections being closed? Commented Nov 9, 2014 at 19:53
  • I have not seen any performance problems when the log backups are being restored on secondary (I am talking about more than 1000+ databases across 30+ instances around the world). For closing connections, there is an option when you configure logshipping to disconnect users when restoring the log files. So selecting that will take care of the users to disconnect. Commented Nov 10, 2014 at 3:10