Why only 1 day of history showing in the Log Shipping history? (88024)

Why only 1 day of history showing in the Log Shipping history?

Log Shipping history retention is always set to 1440 (=1 day) - this is native default for this parameter. There is no GUI option to change it neither in LiteSpeed GUI nor in SSMS dialog.

However, if LiteSpeed uses the native default value (=1440), SSMS set it to 5760

WORKAROUND:
Run the following script to change the history retention period to another value

On publisher:
UPDATE [msdb].[dbo].[log_shipping_monitor_primary]set history_retention_period = 28800 -- ( = 20 days)

On subscriber:
UPDATE [msdb].[dbo].[log_shipping_monitor_secondary]set history_retention_period = 28800 -- (= 20 days)

STATUS:
Enhancement request CR95679 has been submitted to Development for consideration in a future release of LiteSpeed for SQL Server.