Could Replication be the solution!!!?

• mhadi

  SSC Rookie

  Points: 25

  More actions

  April 29, 2004 at 6:55 am

  #179623

  Hi,

  My project manager instructed to develop me a solution: he say

  "Well Mhadi develop an application so that I can have list of available servers (at remote location), check my priveledge for bakup, give the backup file name and send that file to another city so that thay can backup it on it and have another copy on there server"

  I told him that there will be options for acomplishing the same problem but with different way for example "THE REPLICATION"

  Now there is a single subscriber multiple publisher scenario.

  Publishers and subscribers can work autonomously and the application latency too much (end of the day replication)

  All DB servers are using Sql server 2000

  • What type Replication to use?
  • How impleament centeralized approach?
  • What are the confilicts in merge replication?
  • How to get th list of availabe servers situated on different networks and remote locations.
  • Should i use VPN for remote replication.
  • What are these time stamps column?
  • How to impleament on demand replication?
  • And last but not least how do I going to proceed??

  waiting for some serious help

  and thanking inanticipation

  mhadi

  if there is a mistake please tell me but with solution also thankyou

• Alamir

  SSCertifiable

  Points: 6085

  More actions

  May 3, 2004 at 4:29 am

  #504955

  see this site for more help on replication

  http://www.sqlservercentral.com/columnists/mkodli/sql2000replicationarchitecture.asp

  I hope it help u

  
  Alamir Mohamed
  Alamir_mohamed@yahoo.com