Question

  Asked: Apr 30 2008   5:21 PM GMT
  Asked by: SQL Server Ask the Experts


What are the pros and cons for log shipping vs. replication in SQL Server? When is one favored over the other?


SQL Server availability, SQL Server replication, Log Shipping

What are the pros and cons for log shipping vs. replication in SQL Server? When is one favored over the other?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



Both those techniques are used in different situations.

Log shipping is going to be used to get an exact duplicate of the database to another server. It is typically used to create a high availability solution where you can accept a few minutes of data loss. The server which is receiving the logs is left is a state which is not usable by users until fail over is started. Log shipping is typically only setup to go to a single server.

Replication is used to create copies of a specific table, set of tables, or subset of data within a table or tables on one or many other servers. The data can be pushed in near real time, or on a schedule depending on the requirements of the application and the connectivity which the network can support. Replication can be setup to send the same data to several servers at the same time.

While log shipping is used for fail over, Replication is used to get read only copies of the data to users in other locations, or to several servers in the same location to support a very high rate of reads.

Replication can be setup to send inserts, updates and deletes back to the first server in the replication setup (called the publisher), however most people do not need this specific setup.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL and SQL Server.

Looking for relevant SQL Whitepapers? Visit the SearchSQLServer.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   May 2 2008  2:05AM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.