sql server replication: Log Reader Agent -- sql server replication

Re: Log Reader Agent

Ed
9/14/2005 8:33:01 PM

Thanks Hiary,
I thought when I add/edit/delete data in the publisher, then the log
reader agent reads the transaction log on the publisher, it writes data into
a table ("MSrepl_transactions") in the distribution database. Then the
distribution agent move any unmarked data from that table to subscriber(s).
I assume that is true since I did a bit of testing. When I key in any new
data in the publisher, there will be new record(s) in MSrepl_Transactions
with the "entry_time" Timestamp.
Am I correct?
The only thing I cannot see is there are two columns with <Binary> and I am
not sure what they are...

Ed

[quoted text, click to view]

Re: Log Reader Agent

Hilary Cotter
9/14/2005 10:27:13 PM

Could you explain what you mean by "ready to move"?

The log reader agent reads the transaction logs and locates transactions
which have been committed on the publication databases. If these
transactions occurred on tables/indexed views that are marked for
replication, the log reader reassembles these transactions and pushed them
into msrepl_commands. A transaction which affects more than one row is
disassembled into singletons, one singleton for each affected row. The
transaction itself is recorded in msrepl_transactions.

HTH

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

Re: Log Reader Agent

Hilary Cotter
9/15/2005 8:47:10 PM

It writes transaction specific metadata to the msrepl_transaction table. The
transaction is decomposed into SQL statements or proc calls and stored in
msrepl_commands. Otherwise you have an excellent description of how the
replication process works.

Try to query the tables using text mode as opposed to grid mode and you
should see the binary data clear text - the binary data is guids IIRC.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.