Re: How to keep SQL-DMZ and SQL-Internal in sync ?

From: Marlon Brown (nospamarlon_at_hotmail.com)
Date: 06/28/05 

Date: Tue, 28 Jun 2005 07:26:58 -0700

It is a standard web site for my organization. No big urgency to get data
replicated.
Let's say latency <= 1 hour. Is that OK ?

"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:ejFvZJveFHA.580@TK2MSFTNGP15.phx.gbl...
> SQL Server Replication is an option.
>
> What latency can you have?
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "Marlon Brown" <nospamarlon@hotmail.com> wrote in message
> news:edacEAreFHA.688@TK2MSFTNGP14.phx.gbl...
>> If I decide to place a SQL db in the DMZ so that the SQL-db-DMZ can
>> retrieve info from the SQL-db-internal-SAN, what would be best way to
>> sync such database from SQL-db-internal-SAN to the SQL-db-DMZ ?
>> I mean in the past I used robocopy tools to help me keep folders in sync
>> from DMZ-servers to DMZ-staging servers, but I would like to find out
>> what would be the best tool to accomplish this in SQL ?
>>
>>
>
>

Relevant Pages

  • Re: Transactional Replication
    ... For very fast latency and automatic failover there is clustering, ... replication with queued updating subscribers, ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Real time replication over geographically divers sites
    ... That depends on what the cost of latency is. ... For something like this you should probably look at a citrix solution where ... you can probably do this using replication if you relax the latency ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • 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)
  • Re: High Availability
    ... also does failover. ... Async replication is real-time, as opposed to the scheduled Log Shipping ... > Note that one of the considerations for the active/passive GEO Cluster is ... > SQL Server 2000 High Availability Series ...
    (microsoft.public.sqlserver.clustering)
  • Re: Snapshot Creation
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... The Microsoft AD account under which the Snapshot agent (and other ...
    (microsoft.public.sqlserver.replication)