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

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.