How to find Database Present in Log Shpping, Mirroring through T-SQL

• siddiquiakmal

  Valued Member

  Points: 74

  More actions

  January 25, 2013 at 5:58 am

  #273240

  I want to retrieve All the database participating in Log Shipping, Mirroring through T-SQL can anyone provide me the query.

  All the SQL job present on SQL server with their Updated status through T-SQL.

  Can anyone Provide me the Query’s ? Help would be greatly appreciated.

• Perry Whittle

  SSC Guru

  Points: 234065

  More actions

  January 25, 2013 at 6:43 am

  #1581008

  The following when executed against the LS primary databases instance will return configuration info

  exec sp_help_log_shipping_primary_database 'primaryLSdb'

  The following when executed against the LS secondary databases instance will return configuration info

  exec sp_help_log_shipping_secondary_database 'secondaryLSdb'

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉