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

How synchronize database sql server 2012 between two computer? Expand / Collapse
Author
Message
Posted Monday, February 25, 2013 8:50 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 27, 2013 8:10 AM
Points: 3, Visits: 9
After i copy the database from another computer,how i synchronize the database between two computer and different server?When the server updated how my local Database also updated? And the sql server agent cannot running while the sql server running?
Post #1423867
Posted Wednesday, February 27, 2013 8:23 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 08, 2014 5:23 PM
Points: 1,030, Visits: 2,790
You have several options for maintaining multiple copies of a database in 2012

Availability Groups
Mirroring - Which I think is deprecated but you can still use it
Log Shipping
Replication


Gethyn Ellis

gethynellis.com
Post #1424563
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse