Post reply

log shipping

  • 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

  • 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)

Viewing 2 posts - 1 through 1 (of 1 total)

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