| Author |
Topic |
|
cosy
Starting Member
22 Posts |
 Posted - 2007-06-08 : 07:44:48
|
| 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 thisweb SQL server<--->DMZ-->100MB Switch---> 100MB PIX Firewall----> 1GB Switch---->1 GB SQL Serverany third party product if easy or can we use Symantec Backup exec? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-08 : 13:28:17
|
| Is sql port onen on firewall? |
 |
|
|
cosy
Starting Member
22 Posts |
Posted - 2007-06-09 : 03:18:46
|
| HI, Yes, I can connect to DB's. This snapshot replication was fine last few weeks and failed since then we are having this error and take so long to end. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-09 : 20:59:30
|
| Sql service is running on both servers? |
|
|
|
cosy
Starting Member
22 Posts |
Posted - 2007-06-09 : 23:35:32
|
| HI Rmiao, I know you trying to help me out but tell me what you trying to figure out ? yes SQl and Agent running fine. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-10 : 16:15:45
|
| Try to kwon your environment to figure out cause of the error. No one can tell you what's wrong without details. |
|
|
|
cosy
Starting Member
22 Posts |
Posted - 2007-06-11 : 19:39:11
|
| HI, Thanks, I know it's hard. I got 2 DB's and 15 tables and 5-7 GB Data. As i said i got 100MB link and with Snapshot take ages to complete.I just thought of use red-gate SQL Data Compare to do this job? Or Veritas Backup exec? What do you think? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-11 : 20:01:30
|
| How often do you need to sync dbs? Require real time db sync all the time? |
|
|
|
cosy
Starting Member
22 Posts |
Posted - 2007-06-15 : 18:32:16
|
| No need to sync in real time over night is fine |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-15 : 23:01:27
|
| Possible to do backup/restore? |
|
|
|
|
LAN to DMZ SQL Replication