I just started working in a new company, and I am responsible for the reporting SQL server. Their process, in order to keep the db report in sync with the production of db, is to keep the db in standby / read-only mode so that they can use the transaction log that comes every night from the production database.
I need to grab a copy of the current db report so that I can put it on a test server, unfortunately I can not take its full backup in a standby / read-only state.
I understand that I can extract it from this mode by doing "restore the database" dbname "with recovery." However, after I do this, can I put db back in / read-only mode to continue using the nightly transaction log?
source
share