Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Updating multipe databases on multiple serves Expand / Collapse
Author
Message
Posted Tuesday, April 2, 2013 4:19 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 11:38 AM
Points: 66, Visits: 430
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 .
Post #1438125
Posted Tuesday, April 2, 2013 9:13 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:24 AM
Points: 1,264, Visits: 734
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/
Post #1438154
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse