Below system tables in msdb database are used to capture the logshipping related information in Primary,secondary and monitor servers.
msdb..logshipping_primary_databases
msdb..log_shipping_secondary_databases
msdb..logshipping_secondary
msdb..log_shipping_primary_secondaries->Maps Each Primary database to its secondary database
msdb..log_shipping_monitor_primary
msdb..log_shipping_monitor_secondary-
msdb..log_shipping_monitor_history_detail->History of logshipping jobs
msdb..log_shipping_monitor_error_detail->error details of Logshipping jobs
msdb..log_shipping_monitor_alert->Alert Job ID
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment