By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,086 Members | 1,452 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,086 IT Pros & Developers. It's quick & easy.

force rollforward pending state

P: n/a
GB
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.