Log Shipping Backup grey in Transaction Log Shipping Status

by KittyGalore   Last Updated May 16, 2019 03:06 AM

I have slow network that makes configure log shipping via GUI always timeout, so I generate script and run it in both primary server and secondary server.

The scripts work fine but the primary database not show in secondary server log shipping report if I select [msdb].[dbo].log_shipping_monitor_primary in secondary server my primary database not insert at that table.

  1. Is there possibly something wrong when I generate or run logshipping script that makes it not configure properly?
  2. How to fix this, can I manually insert at [msdb].[dbo].log_shipping_monitor_primary or it not enough?

Currently the backup,copy and restore works fine in my server just backup status not show at report transaction log shipping.



Related Questions


Updated April 14, 2015 23:02 PM

Updated May 05, 2015 21:02 PM

Updated March 20, 2016 08:02 AM

Updated January 05, 2017 08:02 AM

Updated July 08, 2015 13:02 PM