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

[@sanju-tr3gz]

Thank you sir meru chala baga cheppthunaru classes ani so migration topic kuda cheppandi sir

[@sanju-tr3gz]

THANKS and Explain about MIGRATION SQL SERVER TOPIC

[@righttolearnbk]

Sure. Will explain about inplace & side by side migration.

[@upentalks]

Thanks BK sir

[@chithravinodham]

Nice sir 👍👍

[@ramkandula1172]

ThankQ sir , Could you explain real scenarios and real time tasks like..

[@Preetiwaghmareh]

Can u plz provide sql dba interview questions of whole syllabus

[@dhilkushistudy]

Sir I took full backup and differential backup in first instance server but I cannot restore 2nd instance server it shows error please tell me solution sir

[@righttolearnbk]

Hope you are restoring full backup first. Please send me a email with the details steps you are doing along with error stack

[@SB29240]

Hi Balu

[@all_IN--1]

Hii bro please provide migration vedios

[@righttolearnbk]

👍