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?