Re: Replication and secure off-site servers

Michael,
some people have used transactional replication for this purposes. To keep
the 2 systems entirely in sync will require careful planning though, as not
all objects can be replicated - eg permissions, users and indexes, and by
default you'll lose identity attributes. Certainly I can see queued updating
subscribers being used in this way, which avoids the issues of not having
the identity columns, but it still leaves the matter of the other objects
being manually synchronized. Log shipping on the other hand will take all
the extra objects. In theory the log could be shipped once a minute but in
my experience you'll be pushing it to get a very low latency. I suspect this
might be the best option for your case.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)


.

Relevant Pages

  • Re: Problem in the rda.Push operation
    ... I would not suggest using IDENTITY columns with RDA. ... The error message you are receiving sounds more like a Merge replication ... For some reason, SQL Server ...
    (microsoft.public.sqlserver.ce)
  • Re: Replication solution?
    ... Replication is your solution for distributed transaction processing...but ... some cases replication makes changes to the schema. ... identical SQL Server in the Ottawa would make it faster for the Ottawa ... I don't think log shipping would do us any good since we need two active ...
    (microsoft.public.sqlserver.replication)
  • Re: Alternate to SQL Replication
    ... Log shipping - whether manual or through the wizard won't really do it for ... The same would apply to shipping the database backups. ... Transactional replication is out because you don't have PKs, ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server 2000 + Remote Mirroring
    ... the first thing is that a cluster will protect from hardware failure ... Log shipping will also work and provide both data and hardware redundancy. ... I'm not sure why you've ruled out replication, although I see this done way ... Replication is going to introduce 3 jobs into SQL Server Agent that will ...
    (microsoft.public.sqlserver.clustering)
  • Re: Transactional replication from SQL Server 2005 to SQL Server 7 - how?
    ... SQL Server 7.0 from the SQL2005 management tools but I would encourage to ... primary keys are replicated as unique indexes if you ... configure replication using the SQL2000 Enterprise Manager. ... If you plan to reinitialize your SQL2000->SQL2005 subscription in the ...
    (microsoft.public.sqlserver.replication)
Loading