log shipping primary server

  • I am connected on secondary server. I know that this is secondary as my DB is in standby mode. How to find the name of primary server for this logshipping set up.

    -LK

  • I tried following queries but did get nothing:

    select * from log_shipping_monitor_alert

    select * from log_shipping_monitor_error_detail

    select * from log_shipping_monitor_history_detail

    select * from log_shipping_monitor_primary

    select * from log_shipping_monitor_secondary

    select * from log_shipping_primaries

    select * from log_shipping_primary_databases

    select * from log_shipping_primary_secondaries

    select * from log_shipping_secondaries

    select * from log_shipping_secondary

    select * from log_shipping_secondary_databases

    -LK

  • Run under master database on secodary server:

    sp_help_log_shipping_monitor_secondary

    @secondary_server = 'secservername',

    @secondary_database =secondarydatabase

    sp_help_log_shipping_secondary_database @secondary_database ='secondarydbname', @secondary_ID = 'outputfromabovequery'

    MJ

  • Excellent.

    Thanks,

    Nagaraju D

  • Hi,

    Thanks for the query.

    Had run the 1st query and based on the info from the 1st query, executed the 2nd query on my secondary DB, but it hit with some errors as shown below.

    2nd query:

    sp_help_log_shipping_secondary_database @secondary_database ='secondarydbname', @secondary_ID = 'outputfromabovequery'

    Output:

    Msg 8145, Level 16, State 1, Procedure sp_help_log_shipping_secondary_database, Line 0

    @secondary_ID is not a parameter for procedure sp_help_log_shipping_secondary_database.

    Did I miss out anything?

    Thanks.

    - Peter

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

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