SQL REPLICATION

Question

SQL REPLICATION

scorpianprince

SSC Eights!

Points: 908
More actions
January 26, 2011 at 12:26 am

#146857

Replication is a process which works on the "store and forward" concept
Can somebody explain me about this process and what all steps are their and how to monitor the replication
Define latency?
How to check the latency of replication?
What to do when replication is intializing?
NEVER NEVER EVER GIVE UP;-)

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Open SQL Books online (the help file that comes with SQL Server), select the content tab in the left pane, expand out SQL 2005, click on Replication. Start reading.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

scorpianprince SSC Eights! Points: 908 More actions · Answer 2

i Hope if you could give me some brief summary

NEVER NEVER EVER GIVE UP;-)

Satnam Singh Hall of Fame Points: 3542 More actions · Answer 3

If u want to know how to set up replication for eg transactional replication, then here is the link,

http://www.sql-server-performance.com/articles/per/transactional_replication_2008_r2_p1.aspx

If u want to setup alert emails, though u can do it using predefined alerts in SSMS but here is a link which contains user defined approach:

http://www.sql-server-performance.com/articles/dba/email_alerts_notification_p1.aspx

Latency is the time it takes for the data to propogate from the publisher to the subscriber.In order to view it just open the Replication Monitor, there u will be able to view.

Hope this helps.

Satnam

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

http://msdn.microsoft.com/library/ms166367.aspx

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

RML51 SSCarpal Tunnel Points: 4410 More actions · Answer 5

There are basically 3 types of replication: Transactional, Merge, and Snapshot. Transactional is the most common of the 3.

Think of it as a newspaper or magazine publication that's delivered to your home. There are three actions involved: 1. The Publisher (who prints/publishes the newspaper or magazine), 2. The Distributor (the paper-boy/girl, or postal delivery person), and 3. The Subscriber (you, at your home, who reads the newspaper or magazine).

Latency is the time it takes for the Publisher to get the newspaper/magazine to the Distributor, plus the time it takes for the Distributor to deliver the newspaper/magazine to your home. You can use Replication Monitor to view the amount of time for these two processes.

There are multiple online resources for you to explore for more detailed information on all types of replication.