get list of log shipping configured databases

• gary1

  SSC-Insane

  Points: 21152

  More actions

  October 5, 2013 at 12:04 pm

  #299465

  Hi,

  How can I get list of log shipping configured databases?

• Loundy

  SSCertifiable

  Points: 6080

  More actions

  October 6, 2013 at 12:53 am

  #1656146

  Could try this...

  select * from msdb.dbo.log_shipping_primary_databases

  http://technet.microsoft.com/en-us/library/ms190355.aspx

  [font="Times New Roman"]There's no kill switch on awesome![/font]