replication setup help

Can someone give me a pointer on how to set up a replication server?
I've browsed the replication documentation, but I just want to know
what the experts suggest for what I want to do.
I have two servers, Office and Home, with Internet access over 384k
DSL line. Office is the publisher, and Home is the subscriber. Home
should be synchronized to Office each night. It is a one-way
replication, i.e. mirroring. The database is many gigabytes, so
snapshot replication is not possible over DSL. Only additions and
changes must be transmitted. What is your suggestion? Should I look
into some third-party software?
Thanks,
Shailesh
Hi Shailesh,
From your descriptions, I understood that you would like to setup
Replication between your Office and Home via DSL. Home is supposed to be
synchronized every night. Have I understood you? Correct me if I was wrong.
Based on my scope, Transactional Replication might be the suitable one for
you. I am afraid you will have to following the document Paul Ibison
listed. Espacially Chapter "Set Up Replication Between Two Computers
Running SQL Server Across the Internet" show you how to configure SQL
Server Replication via Internet correctly.
HOW TO: Replicate Between Computers Running SQL Server in Non-Trusted
Domains or Across the Internet
http://support.microsoft.com/default...b;EN-US;321822
Please understand that Replication Issues may be complicated so that you
will have to spend more time making it through. Here some more documents
that I think might be helpful to you.
HOW TO: Manually Synchronize Replication Subscriptions by Using Backup or
Restore
http://support.microsoft.com/default...b;EN-US;320499
SQL Server Replication Setup
http://www.databasejournal.com/featu...le.php/1459011
Troubleshooting Replication Problems
http://www.databasejournal.com/featu...le.php/1468971
If you would like to show you step by step on how to setup transactional
replication between your HOME and OFFICE, I need more information about
scenario.
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
This document contains references to a third party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.
|||Hi Shailesh,
I am just checking on your progress regarding the information that was sent
you! I wonder how the testing is going. If you encounter any difficulty,
please do not hesitate to let me know. Please post here and let me know the
status of your issue. Without your further information, it's very hard for
me to continue with the troubleshooting.
Looking forward to hearing from you soon
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!