July 9, 2009 at 7:28 am
What are system tables used in Sql server Log shipping
August 5, 2009 at 10:28 am
Hello srikanth.katta1,
Details.
http://msdn.microsoft.com/en-us/library/ms190355.aspx
The following are the system tables used by log-shipping.
log_shipping_monitor_alert (Transact-SQL)
Stores alert job IDs for log shipping.
log_shipping_monitor_error_detail (Transact-SQL)
Stores error detail for log shipping jobs.
log_shipping_monitor_history_detail (Transact-SQL)
Stores history details for log shipping jobs.
log_shipping_monitor_primary (Transact-SQL)
Stores one monitor record per primary database in each log shipping configuration.
log_shipping_monitor_secondary (Transact-SQL)
Stores one monitor record per secondary database in a log shipping configuration.
log_shipping_primary_databases (Transact-SQL)
Stores one record for the primary database in a log shipping configuration.
log_shipping_primary_secondaries (Transact-SQL)
Maps each primary database to its secondary databases. This
log_shipping_secondary (Transact-SQL)
Stores one record per secondary ID.
log_shipping_secondary_databases (Transact-SQL)
Stores one record per secondary database in a log shipping configuration.
Regards,
Victor Alvarez
http://sqlpost.blogspot.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply