SQL Server Performance

LAN to DMZ replication Setup

Discussion in 'Performance Tuning for SQL Server Replication' started by mcosy, Jun 7, 2007.

  1. mcosy New Member

    HI All,

    I got my main sql 2000 Server in LAN and i need to replicate 2 Databases and each got 15 tabels and all these tabels got 5-7GB Data.

    My Web Server in DMZ and running SQL 2000. I need my main Sql to replicate to this web server in DMZ.

    Please tell me what is the best way to full fill my task.

    I'm trying Snapshot each night and it's failing somehow. With following error.

    "The job was stopped prior to completion by Shutdown Sequence 0"

    I know some of the tabels doesn't have the Primery Keys on my main Server.
    if i run this replication manually, it's take for ever to finnished????

    network Setup like this

    web SQL server<--->DMZ-->100MB Switch---> 100MB PIX Firewall----> 1GB Switch---->1 GB SQL Server

    any third party product if easy or can we use Symantec Backup exec?
  2. MohammedU New Member

    If you don't want real time data why don't you do backup restore which will be fater than snapshot replication?


    All postings are provided “AS IS” with no warranties for accuracy.
  3. mcosy New Member


    You mean setup Database restore from Veritas Backup Software?


Share This Page