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 | .tuf fi...
Log Shipping : • Log Shipping in SQL server || Log Shipping...
What is a WRK file : • What is a WRK file in SQL server | .wrk fi...