Competition: What’s your favorite Redgate tool? Enter now.
Log Shipped Database left restoring
I am trying to set up log shipping and have the following problem. The log is copied and restored, and move into the processed folder. If I execute RESTORE DATABASE <name> WITH RECOVERT it will go into an operational state. The problem is that after a log is restore it stays in a restore state, and doesnâ€™t go into a Standby/Readonly state. Anyone else seen this, or have any ideas of what I may be doing wrong?
0 · Share on Twitter