Replicating the same database in two SQL Servers

Replicating the same database in two SQL Servers

I want to know how to use replication for the same database in two SQL Servers. What is function of publication and subscription? My objective of data replication is to reduce the workload of one SQL Server.

    Requires Free Membership to View

    When you register, you’ll also receive targeted emails from my team of award-winning editorial writers.  Our goal is to keep you informed on the hottest topics and biggest challenges faced by today's SQL Server database pros.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at [email protected].

Take a look at this replication primer:
http://www.mssqlserver.com/replication/primer_p1.asp

For More Information

This was first published in April 2004