Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Error when setting up log shipping: "Could not find stored procedure 'dbo.SLS_LogShipping_AddPlan
설명
Error when setting up log shipping:
"Unable to successfully execute SLS_LogShipping_AddPlan for Publisher! Error: Could not find stored procedure 'dbo.SLS_LogShipping_AddPlan'. Unable to successfully add subscriber for "InstanceName"and "Instance Name" due to Error executing SLS_LogShipping_AddPlan for subscriber! Error: Could not find stored procedure 'dbo.SLS_LogShipping_AddPlan'. Plan failed to install. Removing plan. Unable to successfully execute SLS_Remove_Plan. Error: Could not find stored procedure 'dbo.SLS_Remove_Plan'."
원인
Log Shipping wizard requires Local repositories configuration.
해결 방안
Log Shipping Wizard requires LiteSpeed Local repositories and it also requires that all local repositories databases have the same database name.
For example, when implementing Log Shipping from a Publisher and two Subscribers, all of these three servers will need to have a Local Repository installed and all of these three repositories database must have the same name; for instance, the default name: LiteSpeed Local, regardless where the central repository is configured.
추가 정보
Applies to LiteSpeed version 4.6.279 and later versions and all versions of SQL Server
