How to Switch Recovery Mode for the Subscriber database in an existing Log Shipping Plan? (4354406)

When using an existing LiteSpeed Log Shipping plan, how to Switch Recovery Mode for the Subscriber database?

N/A

Switching Recovery Mode in between Loading to Read Only(Standby):

1.  Find the PlanID of the log shipping plan by running the following query in Query Analyzer:

Select * from LSPlans

2.   Then run the following script:

update LSDataBasePlans
set RecoveryMode = 1 -- 0 is Loading, 1 is Read Only
where PlanID = '<PlanID>' and Role = 1 -- <PlanID> is the PlanID of the plan you want to modify

NOTE: The above update script  must be run on both publisher and subscriber.