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

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 06/27/05

  • Next message: Gabe Matteson: "SQL Agent Account" 
    Date: Mon, 27 Jun 2005 10:29:16 +0200

    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 ?
    >
    >

  • Next message: Gabe Matteson: "SQL Agent Account"

    Relevant Pages