[6.5] [Log Shipping] Error "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression." occurs when you edit subscriber if any of subscriber's jobs (Copy or Restore) has more than one schedule
LiteSpeed doe snot handle the situation when log shipping job has multiple schedules.
WORKAROUND:
Attached are two stored procedures (one for Publisher, another for Subscriber) where the issue with multiple schedules has been resolved. Then you can edit an existing log shipping plan so that to specify backup, copy and restore interval (every 15 min is by default). All other schedules will remain.
You need to update those proc on local repository.
STATUS:
Issue fixed in version 7.0 or LiteSpeed for SQL Server. The latest version of LiteSpeed for SQL Server can be downloaded at: http://support.quest.com/support_download/Downloads.asp
