How to execute the store procedure SLS_LogShipping_Restore_Secondary manually?
The documentation regarding stored procedure SLS_LogShipping_Restore_Secondary shows command usage as follows:
SLS_LogShipping_Restore_Secondary
@PlanID
, @PlanName
, @Recover
, @DataBaseName
SLS_LogShipping_Restore_Secondary is used to restore the logs as part of the normal log shipping process and it is also used to bring a subscriber database completely out of a loading state and into a regular read/write state, by using the parameter Recover=2.
PlanID: you must specify either the PlanID or the PlanName.
PlanName: you must specify either the PlanID or the PlanName.
Recover: 0 = loading, 1 = read only, 2 = full recovery.
DatabaseName: only used for full recovery of the database.
Example:
SLS_LogShipping_Restore_Secondary
@PlanID = '66A696B2-CEC8-4289-BBB2-E1D0C0114B0D'
, @PlanName = 'LiteSpeed LogShipping for Northwind'
, @Recover = 1
, @DataBaseName = 'Northwind'
Also see Solution 31486
