log shipping

• Zeal-DBA

  SSCarpal Tunnel

  Points: 4332

  More actions

  October 12, 2010 at 3:36 am

  #225012

  hello experts

  i have 800 databases on my server, some are configurd with logshipping and some are not configured, how can i get list of databases which are not configured with log shipping??

  its urgent

  thank you

• Geoff A

  SSChampion

  Points: 11511

  More actions

  October 12, 2010 at 9:11 am

  #1235612

  I do not have log shipping running anywhere to test this, but i will give you something to start with maybe...

  select [name] from sys.databases where [name] not in (select primary_database from msdb.dbo.log_shipping_primary_databases)