title: Log-Shipping: Why would you choose No Recovery mode?
body: <p>When configuring LogShipping for SQL Server, you can choose for the secondary database to be in No Recovery mode or Standby mode.  No Recovery means you have no access to the database while log shipping is going on. Standby gives you read-only access, and if you select the option to disconnect users whenever a restore is about to happen, would appear not to interfere with the log shipping process. This looks to me like an extra benefit of standby mode, but as far as I can see the documention mentions no adverse affects.</p>
  
  <p>I'm therefore wondering why anyone would choose to use No Recovery mode? The only plausible reasons I can think of are if Standby mode caused a significant performance degredation (but there's no mention of anything like that in the docs), or if there is some security requirement to actively prevent anyone seeing the contents of the secondary database (which would seem rare/unlikely).</p>
  
  <p>Can anyone enlighten me what the advantage of choosing No Recovery mode is supposed to be?</p>