If I execute the script, get the out put from two servers

  • Hi,

    Regularly i have taken log shipping report on both primary server and secondary server. 

    I want know, if I am execute the script it will show the output  from both servers.

    Is it possible through cmd or power shell or something, please let me know.

  • Is your query the same you execute on both Primary and Secondary?

    If so you could look at registered servers and create a group where you register both machine and run the query against the group to get a multi server result set.

  • anthony.green - Wednesday, December 20, 2017 7:38 AM

    Is your query the same you execute on both Primary and Secondary?

    If so you could look at registered servers and create a group where you register both machine and run the query against the group to get a multi server result set.

    +1
    😎

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

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