Hi,

Thanks for the query.

Had run the 1st query and based on the info from the 1st query, executed the 2nd query on my secondary DB, but it hit with some errors as shown below.

2nd query:

sp_help_log_shipping_secondary_database @secondary_database ='secondarydbname', @secondary_ID = 'outputfromabovequery'

Output:

Msg 8145, Level 16, State 1, Procedure sp_help_log_shipping_secondary_database, Line 0

@secondary_ID is not a parameter for procedure sp_help_log_shipping_secondary_database.

Did I miss out anything?

Thanks.

- Peter