asked
Log shipping tables on primary and secondary server
In the primary server dbo.log_shipping_monitor_primary has two rows which has two databases and the backup date is from 12-14. In the same server dbo.log_shipping_monitor_secondary is empty. In the secondary server dbo.log_shipping_monitor_primary has two rows and gives the threshhold_alert 14420. In the dbo.logshipping_monitor_secondary shows the threshhold_alert 14421. Am I supposed to see the following in the system databases? I know I have to delete some rows in the msdb table because I created, deleted and re-enabled logshipping and I am getting the event log error: The log shipping primary database server.AbraHRMS_Live has backup threshold of 60 minutes and has not performed a backup log operation for 149482 minutes. Check agent log and logshipping monitor information. Event ID= 14420 ![alt text][1] [1]: /storage/temp/750-config2012-12-17_0943.png
the error you are getting explains that transactio backup jobs are not sucessfully executing on the server. rename you curent database create a blank database with the same name then reconfigure and remove log shipping on the database
Not quiet sure if that is true. The backup, copy and restore jobs view history does not show any error and also the folders created for transactional jobs creates and deletes the log files as scheduled.
Followed the blog
http://www.mssqltips.com/sqlservertip/2799/steps-to-add-log-shipping-monitor-into-an-existing-sql-server/#comments to remove the LS alert messages.
13 People are following this question.
