Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

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?

share
2  
Are you looking for a copy of the whole database on your secondary server, or just a subset of data? – Thomas Stringer Dec 31 '12 at 12:00

migrated from stackoverflow.com Dec 31 '12 at 10:46

closed as too localized by Mark Storey-Smith, dezso, Marian, RolandoMySQLDBA, Jon Seigel yesterday

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, see the FAQ.