In a log shipping scenario I would like to be able to test my database
and set it back manually in roll forward pending state, is it possible ?
What I would like to do in detail:
- On the backup site: restore the main backup, rollforward the logs,
ship new logs,rollforward the logs, ... (all this works)
- I would like to be able to test from time to time the state of the
database, so I stop the rollforward pending state, I do some read
requests. (this works also)
- Then I would like to restart importing new logs and I need for this
reason to be able to force the database to go back in roll forward
pending state but I found no way to do it, has someone an answer to this ?
Thanks Greg