Seeing blocking activities in [LiteSpeedLocal] [LogShippingHistory] table when logshipping backup/restore taking place.
blocking statement exmaple:
use [LiteSpeedLocal]
DELETE FROM LogShippingHistory
WHERE PlanID = N'{233DFCBC-4821-41AE-A752-3161AA9EC359}'
AND DATEDIFF (mi, LogTimeStamp, GETDATE ()) >
(SELECT HistoryRetentionPeriod FROM LogShippingSubscriber WHERE PlanID = N'{233DFCBC-4821-41AE-A752-3161AA9EC359}')
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center