i have two test log shipping servers set up. both going to different secondaries but using the same backup location and monitoring server..
Both are working, i get no errors and can look on the secondaries and see up to date info for the last backups.
So why in msdb tables. does one have NULLs for restored_file and date
SELECT primary_database ,
for everything except last_restored_date and last_restored_date_utc
But the other has all those details filled in.
Hope someone can help.
I decided to remove the log shipping that was having NULLS (I dont have NULLS anymore.. Any ideas what i did to cause that???)
Also can you only have one log shipping DB monitored by a instance? I give each db monitor job a different name but Its just replaced the old monitoring job for the other db.. (didnt notice before) I cant see any reference in BOL.