How synchronize database sql server 2012 between two computer?

• sadnesslyp

  SSC Journeyman

  Points: 99

  More actions

  February 25, 2013 at 8:50 pm

  #274562

  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?

• GRE (Gethyn Ellis)

  SSCrazy Eights

  Points: 9602

  More actions

  February 27, 2013 at 8:23 am

  #1591579

  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 Elliswww.gethynellis.com