Easy Question about transaction logs

  • 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.

  • 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.

  • Thanks Guys!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply