Log Shipping: It's Better Than Bad It's Good!

Useful Log Shipping Script

SELECT ls.primary_server AS [primaryServer] ,ls.primary_database AS [primaryDB] ,lsd.secondary_database AS [secondaryDB] ,lsd.restore_delay AS [restoreDelay] ,CONVERT(VARCHAR, DATEDIFF(SECOND, lms.last_restored_date, GETDATE()) / (60 * 60 * 24)) + '_' + CONVERT(VARCHAR, DATEADD(s, DATEDIFF(SECOND, lms.last_restored_date, GETDATE()), CONVERT(DATETIME2, '0001-01-01')), 108) AS [timeSinceLastRestore dd_hh:mm:ss] ,CONVERT (VARCHAR (20), lms.last_copied_date, 120) AS [lastCopiedDate] ,CONVERT (VARCHAR (20), lms.last_restored_date, 120) AS [lastRestoredDate] ,lms.last_copied_file AS [lastCopiedFile] ,lms.last_restored_file AS [lastRestoredFile] ,lsd.disconnect_users AS [disconnectUsers] ,ls.backup_source_directory AS [backupSourceDirectory] ,ls.backup_destination_directory AS [backupDestinationDirectory] ,ls.monitor_server AS [monitorServer] FROM msdb.