January 23, 2018 at 5:36 pm
Using SQL2008R2, I have a general, basic SQL transnational replication question.
It is my understanding Log Reader reads the transaction log of a database to determine what needs to be replicated.
Is there a command I can run on the transaction log of a publisher database to determine just how many commands are there to be replicated ?
thanks !
January 24, 2018 at 1:32 am
The Replication monitor should be able to supply you with that information.
January 24, 2018 at 8:27 am
SQLJay - Tuesday, January 23, 2018 5:36 PMUsing SQL2008R2, I have a general, basic SQL transnational replication question.
It is my understanding Log Reader reads the transaction log of a database to determine what needs to be replicated.Is there a command I can run on the transaction log of a publisher database to determine just how many commands are there to be replicated ?
thanks !
Nothing directly will do that by reading the transaction log. You could try to use fn_dblog and query where the description is replicate and the operation LOP_COMMIT_XACT. Or Replicated records > 0. And then try to map the LSNs for that back to the xact_id for the replication commands.
That seems like a complex way to do it though. You can just select from the MSDistribution_Status table in the distribution database and get the count of delivered and undelivered transactions by article id and agent id.
Sue
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply