July 22, 2009 at 12:09 pm
Started a new DBA job without the benefit of having the previous DBA to help me.
I'm wading through allot of DB's/Servers and looking for any indication of log shipping. Where do I look to verify if log shipping has been setup. I can't seem to find it anywhere.
July 22, 2009 at 12:58 pm
From BOL:
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.
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.
July 22, 2009 at 1:12 pm
a few links: http://msdn.microsoft.com/en-us/library/ms181149.aspx
Log shipping tables in here: http://msdn.microsoft.com/en-us/library/aa260604(SQL.80).aspx
July 22, 2009 at 3:01 pm
Thanks Guys!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply