LAN to DMZ replication Setup | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

LAN to DMZ replication Setup

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?

If you don’t want real time data why don’t you do backup restore which will be fater than snapshot replication?
Moderator All postings are provided “AS IS” with no warranties for accuracy.

HI, You mean setup Database restore from Veritas Backup Software? cosy