title: SQL 2005 in Standby / Read-Only Mode - Can I recover the db to take a backup and then continue applying transaction logs?
body: <p>I just started at a new company and I'm responsible for the reporting sql server.  Their process to keep the reporting db in sync with the production db is to constantly keep the production db in Standby/Read-Only mode so that they can apply a transaction log that comes each night from the production db.</p>
  
  <p>What I need is to grab a copy of the current reporting db so that I can put it on a test server, unfortunately I can't take a full backup of it in the standby/read-only state.</p>
  
  <p>I realize that I can get it out of that mode by doing "restore database 'dbname' with recovery".  However after I do that, can I get the db back into the Standby/Read-Only mode to continue applying the nightly transaction log?</p>