I have a database server, SQL Server 2008, that's inside a private network. Now I need to make a database there available for a web server for my web application so that people don't need to come to my office they can view their info any where, so I want to replicate this db to an external server, which is running SQL Server 2008. I want the internal server to be the Master and the external one, the slave. New data will be added a few times a day maybe, infrequently, and should be replicated smoothly without manually intervention.
How do I solve this issue?