Updating multipe databases on multiple serves

• wannabe dba

  SSCommitted

  Points: 1524

  More actions

  April 2, 2013 at 4:19 pm

  #270582

  Is there a way we can update multiple databases on Multiple servers? I am trying to sync multiple databases but do not want to use replication since I only want it run once a day .

• magasvs

  SSCertifiable

  Points: 7660

  More actions

  April 2, 2013 at 9:13 pm

  #1603015

  Yes, you can use Central Management server or Registered Servers. See my post here: http://www.mssqltips.com/sqlservertip/2855/sql-server-multi-database-query-with-registered-servers/%5B/url%5D