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...
Смотрите видео Log Shipping Tables | Monitor Log shipping using MSDB tables | SQL interview questions | Ms SQL онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Right to Learn @BK 10 Сентябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 5,177 раз и оно понравилось 118 людям.