Re: Replication and secure off-site servers

How does that work when there is a firewall between the Production server
and the hot-copy?

"Paul Ibison" <Paul.Ibison@xxxxxxxxxxxxx> wrote in message
news:ekPb3DboFHA.3316@xxxxxxxxxxxxxxxxxxxxxxx
> 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: SBS 2003 and Replication Errors with Remote DC
    ... I just promoted the remote DC last week, so I still have time to solve the replication issues. ... Domain Controller Diagnosis ... Connecting to directory service on server alpha. ... Performing upstream analysis. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Replication Errors with Remote DC
    ... alpha server as soon as you can to get things going. ... A simple DNS replication test is to create a host record in the SBS server ... Domain Controller Diagnosis ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Replication Errors with Remote DC
    ... I did make the changes that you suggested on the DNS of my alpha server and rebooted. ... I did run the simple DNS test that you suggested by adding a host record to my SBS server. ... A simple DNS replication test is to create a host record in the SBS server and wait till it shows up in the remote server. ...
    (microsoft.public.windows.server.sbs)
  • Re: How to Replicate an SQL Server 2000 Database
    ... Looking for a SQL Server replication book? ... actual server name) enterprise manager should associate the database with ...
    (microsoft.public.sqlserver.replication)
  • Re: How to Replicate an SQL Server 2000 Database
    ... Looking for a SQL Server replication book? ... actual server name) enterprise manager should associate the database with ...
    (microsoft.public.sqlserver.replication)
Loading