Post reply

log shipping primary server

  • August 21, 2009 at 9:18 am

    #156133

    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

  • August 21, 2009 at 9:18 am

    #1042912

    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

  • August 24, 2009 at 5:39 pm

    #1043945

    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

  • January 4, 2015 at 6:10 pm

    #1767648

    Excellent.

    Thanks,

    Nagaraju D

  • January 12, 2015 at 8:03 pm

    #1769687

    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