Log Shipping Tables | Monitor Log shipping using MSDB tables | SQL interview questions | Ms SQL

In this video i have explained about Log shipping tables and how to monitor Log shipping using these tables.

select * from msdb.dbo.log_shipping_primary_secondaries -- To check for secondary server instance

select * from msdb.dbo.log_shipping_primary_databases

select * from log_shipping_monitor_primary ---Look for last backup file

select * from msdb.dbo.log_shipping_monitor_error_detail -- Showup details of error when a job is failed

select * from msdb.dbo.log_shipping_monitor_history_detail


--**SECONDARY
select * from msdb.dbo.log_shipping_monitor_secondary -- Primary & secondary along with Cop & restore file details

select * from msdb.dbo.log_shipping_secondary --Look for only last copied file & Primary server instance
select * from msdb.dbo.log_shipping_secondary_databases -- Look for last restored file


TUF file :    • What is a TUF file in SQL server | .t...  
Log Shipping :    • Log Shipping in SQL server || Log Shi...  
What is a WRK file :    • What is a WRK file in SQL server | .w...