question

Teciluas avatar image
Teciluas asked

Log Shipping databases has backup/restore threshold false positive error

Hello, In my test environment ( Two Windows Server 2012R2 with SQL server 2014 Standard Edition) i have created multiple primary and secondary databases to test Log Shipping scenarios. After a while, i had more than 50 databases on primary and secondary and hundreds of SQL jobs. So clear things a bit, i dispose of them all so i could work freely again on these servers. Problem is, now in server event logs viewer, i have multiple false positive report of databases that haven't been backed-up/restored according to a predefined threshold reached for xxx minutes. Using my favorite search engine, i came up with the below two stored procedure: -- On secondary Use [Master] sp_delete_log_shipping_secondary_database @secondary_database = 'dbname' GO -- On primary Use [master] GO sp_delete_log_shipping_primary_secondary @primary_database = 'dbname', @secondary_server = 'secondarySERVER', @secondary_database = 'dbname' GO Running the above gave me a "query successful execution" message, but after restarting both servers to make sure all things are well taken into account, nothing changed. Still got the message in windows event logs: Backup: The log shipping primary database SERVER2.dbname has backup threshold of 60 minutes and has not performed a backup log operation for 9697 minutes. Check agent log and logshipping monitor information. Restore: The log shipping secondary database SERVER1.dbname has restore threshold of 30 minutes and is out of sync. No restore was performed for 5751 minutes. Restored latency is 0 minutes. Check agent log and logshipping monitor information. Reaching the end of my possibilities, i'm coming to seek ya'll help if anyone of ya'll have stumbled upon such porblem and get it resolved? Many thanks for your help! T.
log-shippingmonitoringlogsql-server-2014-standard
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.