• query the logshipping tables in msdb